Good morning.

In Excel 2003, I know you can have three criteria of sorting (Sort by
Then by, Then by).

I am trying to create a form where I give the user the same 6 option
(representing columns D through I of the sheet) for sorting. I hav
form controls to stop sorting the same column more than once but I'
just not sure what the VBA should be for the sort.

Can I use variables and pass them to a single sort statement?

Do I need different sort statements if they want to sort by 1, 2, or
criteria?

Thanks,
Jorda

--
Message posted from http://www.ExcelForum.com