Order of items in ComboBox

[ipbr21054]

Evening,
I have a ComboBox which will start to see more & more entries in its list.
Basically this list is out of order of how i would like to see it.

Very basic example.
I would like to see,
HU56
HU58
HU59
HU100
HU101
Etc etc

The list is as follows,

HU100
HU101
HU56
HU58
HU59

I understand if i add a zero it would then possibly work but i only need it to show like HU59 as opposed to HU059 etc.

Many thanks if you can advise a workaround.
Any code that you need uploading here please ask.

Thanks

 

[jproffer]

Couple questions:

What type of combobox? (I.E.-On a userform or an activeX combobox on a worksheet?)

How are you loading the list? (rowsource....AddItem...what?)

 

[ipbr21054]

Hi,

It’s that file that you downloaded the other day.
It’s also that same combo box.

Just to advise you I continued to use my existing code as opposed your doodle that you sent me.

Thanks.

 

[jproffer]

Oh the key coding/picking etc userform?

If I remember right, you were using Add and looping through cells on a drop down event to load your combobox, right?

So maybe you could sort them in the cells however you want them to load....??


Not sure what you mean by doodle code, but you're (needless to say) free to use whichever code you wish

 

[ipbr21054]

Hi
From memory I think this list was out of order in the code but it made difference to the order that you see in the combo box.

Can you think of another way as opposed the combo box if that’s easier.

 

[jproffer]

Can you post your code again? I don't typically keep workbooks I download after issues are resolved.

If you have a list on a worksheet, you can use the RowSource property instead.

ComboBox1.RowSource = "Sheet1!A1:A20" 'Or whatever your range is

or if it's always the same, you can even do it in the properties window of the combobox and don't even have to code it.

 

[ipbr21054]

Hi,
Here is the download link http://www.mediafire.com/file/aiuzu3vl8w1kdqe/DR.zip/file

Have a play & see what you can do to make it look / feel better etc

Thanks

 

[jproffer]

I looked....they're going to be in the order that you have them on the worksheet ("INFO"). I don't know any way to force it to make the items any order other than that. If you're dead set against re-ordering the items in that worksheet, then I think you're stuck with what you have now.

 

[ipbr21054]

Hi,
I think the best thing to do is insert a column before the current column named KEY TYPE
I will then put the order of numbers in these cells & use that macro button to sort to the numbers that i specify,this will fix it.

Upon inserting a new column i see that the header colors in the table now change from blue to yellow etc.
Can you advise where i need to make the edit to bring the colors back to how they were as i assume adding a new column has put something out of joint.

Thanks