add option to drop down menu

V

Vic

I currently have a drop down menu/combo box in excel and I would like to add
more selections to the drop down menu. Appreciate any hep
 
R

Ramakrishnan Rajamani

Try this

Private Sub ComboBox1_GotFocus()
ComboBox1.Clear
ComboBox1.AddItem "Item 1"
ComboBox1.AddItem "Item 2"
ComboBox1.AddItem "Item 3"
End Sub
 
Top