I've created a user form with 9 drop down fields. User selects which field(s) to sort data sheet by.
Here's the problem for me: I can capture which fields user selects on Datasheet and use that to generate sort Keys but I can't figure out how to get these value(s) (may be only 1 field or could be as many as 9 fields) in the sort part of the macro.

My code below is where I am at right now. I'm sure there is an easier way to do this and would appreciate any suggestions. 

Please Login or Register  to view this content.