Which column(s) are sort keys?

[Guest]

Hi All.....
Can anyone tell me if there is a way through VBA to determine how a database
is sorted....ie: which is the 1st, 2nd, and 3rd sort keys, or even just which
is the first?

Thanks,
Vaya con Dios,
Chuck, CABGx3

 

[Guest]

If you mean with code,
Except by examining the data, I don't believe there is a built in method.

 

[Guest]

Thanks Tom........too bad, I was hoping to be able to lite up column header
cells with the sort-key colors......oh well,

Vaya con Dios,
Chuck, CABGx3

 

[Guest]

You could remove the sort option and replace it with your own interface (a
userform) so you know what selections the user has made.

 

[Guest]

True, I have had the indicators I want working in the past whenever "I"
controlled the sort.......I was just hoping to be able to interrogate an
existing sort to determine the keys.........

Thanks anyway,
Vaya con Dios,
Chuck, CABGx3

 

[Guest]

Which is frustrating since Excel itself is able to repopulate the sort
dialogue correctly - some hidden namespace entry ?