Order of items based on a range being added to a combobox on a userform

[lynnsong986]

Hello,

I have a combobox on a userform where I load a bunch of values based on a range, it is strange to me that the first value appears in the combobox is actually the last value in the range.

for example,

I have in column F (F2:F5)
Marketing
Salaries
R&D
Other Expense

and I have in column G: (G2)
General Admin expense

on initialization/show, the order of the combobox is as "General Admin expense","Marketing","Salaries","R&D",
"Other Expense". I'd like to have the same order as in the range: Marketing","Salaries","R&D",
"Other Expense", "General Admin expense". Can someone please help?

Please Login or Register  to view this content.

thanks!

[lynnsong986]

never mind, I went around it by setting another range combining all items in multiple columns in the order I want, then use that range to load the combobox, it's such a simple solution I didn't think of...