Userform : how to get combobx names in Ascending order

[HaroonSid]

hello
Userform : how to get combobx names in Ascending order
thanx

[romperstomper]

How are you populating the combobox? If it's from a range, you can just sort the range.

[HaroonSid]

yes
it's form range. but i can't sort because range has formulas

[romperstomper]

How are you loading the combobox - using List, AddItem or RowSource?

[HaroonSid]

hello romperstomper

RowSource

[romperstomper]

Then your only options are to sort the range or change the population method. Of course, if you are using RowSource so that you can use ColumnHeads, you'd have to use a workaround since ColumnHeads only works with RowSource.

[HaroonSid]

plz describe the solution

how to use rowsource and columnheads

[romperstomper]

I think you misunderstood. If you are using RowSource, you have to sort the data range. There is no alternative.
If you don't use RowSource, you can sort the data before adding it to the combobox, but you can't have column headers.

[HaroonSid]

romperstomper

My English and excel vba knowledge is weak

so plz u tell what method i use in combobox to sort the data

[romperstomper]

Here's a very basic BubbleSort method:

Please Login or Register  to view this content.

[HaroonSid]

Thanx for reply
now tell me what changing should i do in my userfrom

[romperstomper]

I'm not psychic.

[HaroonSid]

ok thanx a lot for help
i will do

will add u reputaion surely