I used listfillrange to populate my combobox. i been trying to sort m
values in combobox list once it is click but the issue came coz i du
want to sort my main database table.

is there any VB code for autosorting the values in the combobox
currently whenever i click my data userform to cancel, i am calling
macro to copy the entire list of the table, paste somewhere and sort
but this is very slow and look visually ugly..

--
jean
-----------------------------------------------------------------------
jeana's Profile: http://www.excelforum.com/member.php...fo&userid=3267
View this thread: http://www.excelforum.com/showthread.php?threadid=52517