Excel Vba - Userform combobox problem

[stevehorton]

Hi all,

My current code allows someone to to click on the combo box and ente
the first few letters of a word and if it is in the combo box it i
picks up.

How can i change the code so when the arrow button on the combo box th
list of values appear??

Very simple but im lost!

my current code

rivate Sub ComboBox1_Change()
ComboBox1.AddItem "New Entity"
ComboBox1.AddItem "New Location"
ComboBox1.AddItem "New Activity"
ComboBox1.AddItem "New Product"
ComboBox1.AddItem "New Business"
ComboBox1.AddItem "New Project"
ComboBox1.AddItem "Description Change - Entity"
ComboBox1.AddItem "Description Change - Location"
ComboBox1.AddItem "Description Change - Activity"
ComboBox1.AddItem "Description Change - Product"ComboBox1.AddIte
"Close Entity"
ComboBox1.AddItem "Close Location"
ComboBox1.AddItem "Close Activity"
ComboBox1.AddItem "Close Product"
ComboBox1.AddItem "Close Business"
ComboBox1.AddItem "Close Project"
ComboBox1.AddItem "New Cross Validation Rule"
ComboBox1.AddItem "New Alias"
ComboBox1.AddItem "Description Change - Business"
ComboBox1.AddItem "Description Change - Project"
ComboBox1.AddItem "Close whole cost centre"

ComboBox1.Style = fmStyleDropDownCombo
End Su

 

[BrianB]

Your code should go into the form_initialize event otherwise it jus
keeps adding those items every time a change is mad