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
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.