PDA

View Full Version : Solved: sort box



Djblois
08-29-2006, 12:22 PM
I want to open up the built in sort box but I don't remember the code. this is what I have

Application.Dialogs(xlsort).Show

Zack Barresse
08-29-2006, 12:53 PM
Hi there,

You're really close ...

xlDialogSort

mvidas
08-29-2006, 12:55 PM
Hi djblois,

What you're looking for is xlDialogSort.
I do have a question for you though. When you get to the ( in the above statement, ie:Application.Dialogs(do you see a list of the available choices? If not, from the VBA editor go to Tools / Options, then on the Editor tab see if "Auto List Members" is checked. If not, check it, and you should see a list of whats available.
As an example:
http://www.hastalavidas.com/applic.jpg
Matt

Djblois
08-29-2006, 01:20 PM
Thank you both