UserForm ComboBox not working

[Cremorneguy]

Hi there,

I have a ComboBox in a Userform. I have the code with all the items I want in the list but for some reason for it to work, I have to type the letter "L" into the box before the list appears (the list all start with "Level" hence the letter "L").

Is there a way to have it so all you need to do is click on the arrow for the drop box and all the items show up (so you don't need to type in the letter "L").

Currently, my VBA Code is: Is there something I need to change so that the list just appears?

Please Login or Register  to view this content.

[quekbc]

Hi Cremorneguy,

You can use the DropButtonClick event instead. I.e.

Please Login or Register  to view this content.

[Norie]

Put the code to populate the combobox in the form's Initialize event.

Please Login or Register  to view this content.