How about copying the data to a separate range and sorting the range.
Your combo box will still be pointing at the original data.

e.g

Column A1:A10 Data
Combo box points to A1:A10

Macro to copy data to column B
Sort column B


--
Special-K


------------------------------------------------------------------------
Special-K's Profile: http://www.excelforum.com/member.php...fo&userid=7470
View this thread: http://www.excelforum.com/showthread...hreadid=562483