Syed

Here are a few possbile solutions

http://search.atomz.com/search/?sp-q...p-f=ISO-8859-1

If you have trouble implementing these, post back with the specifics of your
situation


--
Dick Kusleika
Excel MVP
Daily Dose of Excel
www.dicks-blog.com

Syed Haider Ali wrote:
Dear Freinds,

I have a worksheet where data is not in a sort order. When i use
comboBox i need code that combobox shows data (Suppose Col A in a
ascending order). But the data on sheet will not effect. ( Only if i
search data through combo Box, it is in comboBox shown in ascending
order)

Thanks

Syed Haider Ali