I have a similar problem with 4 comboboxes on an Excel Userform. Each
comobox has a list from column A, B, C and D. Column A is the
original Sort order by on the worksheet. What I'd like to see is when
I select Combobox2 (which is set for column B) that the order is
ascending, then if I were to switch to Combobox3, set up for column C
that Column C is now sorted in ascending order. If I go back to
Combobox1, which is Column A, this is again sorted. I've worked
through some code, but I get errors as I make a selection from the
list. Thanks!