Hi i want to add an drop down list to a activeX combo box using a VB code. i tried this code but it doesn't work.
Private Sub ComboBox1_Change()
With Sheet1.ComboBox1
.AddItem "Paris"
.AddItem "New York"
.AddItem "London"
End With
End Sub
Thanks!![]()
Bookmarks