PDA

View Full Version : Sort on multiple dynamic columns using excel VBA



Swaminathan
02-09-2016, 10:05 PM
Hi Team,

I have a requirement to sort on multiple columns based on the user input columns. That is, i have a text box in my userform where user can enter the columns on which they want to sort. The columns to sort is dynamic where it may be 1 or 3 or may sometimes 10. I need an excel VBA to achieve this functionality. Can anyone provide me a help on this? I researched forums and found code to sort on multiple columns, but in that case columns are static.

Regards,
Swaminathan