vba OrderCustom=1 是什么意思?

声明:本页面是StackOverFlow热门问题的中英对照翻译,遵循CC BY-SA 4.0协议,如果您需要使用它,必须同样遵循CC BY-SA许可,注明原文地址和作者信息,同时你必须将它归于原作者(不是我):StackOverFlow 原文地址: http://stackoverflow.com/questions/18260064/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me): StackOverFlow

提示:将鼠标放在中文语句上可以显示对应的英文。显示中英文
时间:2020-09-11 22:47:14  来源:igfitidea点击:

What does OrderCustom=1 mean?

excelexcel-vbavba

提问by user1283776

I'm looking at the code below and I can't figure out what OrderCustom=1 means.

我正在查看下面的代码,但我无法弄清楚 OrderCustom=1 是什么意思。

Selection.Sort Key1:=Range("A1"), Order1:=xlAscending _
    , Header:=xlNo, OrderCustom:=1, MatchCase:=False _
        , Orientation:=xlTopToBottom

I've asked google but weren't helped by the first page results. This is also not the first VBA detail question I have not been able to find an answer for. So a bonus question of mine is if you know of a good reference resource where I can lookup things like this?

我问过谷歌,但第一页结果没有帮助。这也不是我找不到答案的第一个 VBA 详细问题。所以我的一个额外问题是,你是否知道一个很好的参考资源,我可以在那里查找这样的东西?

采纳答案by sealz

That implies there is some form of customized ordering on. OrderCustom changes the custom sort property.

这意味着有某种形式的定制订购。OrderCustom 更改自定义排序属性。

Once the CustomOrder is set you should be able to use it as described in your code.

设置 CustomOrder 后,您应该能够按照代码中的描述使用它。

This might explain it better.

这可能会更好地解释它。

The VB Code from here

来自此处的 VB 代码

'Declaration
Property CustomOrder As Object
    Get
    Set
'Usage
Dim instance As SortField
Dim value As Object
value = instance.CustomOrder   
instance.CustomOrder = value