How to sort A to Z data of combobox Userform

[HaroonSid]

Hi,
I have a dynamic name range in combobox
And
I just want to sort that list A to Z when I click combobox


I have also 0 (zero) in my Name range so I don't want to include this 0 in combobox list

[MarvinP]

Hi haroon,

I'd create a second named range that is the sorted (A to Z) of your first named range. Then I'd use this sorted and filtered*range in your combo box. I'd also create a little VBA script that sorted and filtered the first to the second*on some event.

Does that help?

[Maudibe]

Harsoon,

Similar post with answers here: http://www.excelforum.com/showthread...=1#post4575471