Try this

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


"Vic" wrote:

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