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?
Private Sub ComboBox1_Change()
ComboBox1.AddItem "LEVEL 1"
ComboBox1.AddItem "LEVEL 2"
ComboBox1.AddItem "LEVEL 3"
ComboBox1.AddItem "LEVEL 4"
ComboBox1.AddItem "LEVEL 5"
ComboBox1.AddItem "LEVEL 6"
ComboBox1.AddItem "LEVEL 7"
ComboBox1.AddItem "LEVEL 8"
ComboBox1.AddItem "LEVEL 9"
ComboBox1.AddItem "LEVEL 10"
ComboBox1.AddItem "LEVEL 11"
ComboBox1.AddItem "LEVEL 12"
ComboBox1.AddItem "LEVEL 13"
ComboBox1.AddItem "LEVEL 14"
ComboBox1.AddItem "LEVEL 15"
ComboBox1.AddItem "LEVEL 16"
ComboBox1.AddItem "LEVEL 17"
ComboBox1.AddItem "LEVEL 18"
ComboBox1.AddItem "LEVEL 19"
ComboBox1.AddItem "LEVEL 20"
End Sub
Bookmarks