LinkBack URL
About LinkBacks
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!
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!
That code will only trigger when you type something in the combobox, which is probably a bit late. Try the worksheet_Activate event or workbook_open instead.
Remember what the dormouse said
Feed your head
Hi Romperstomper,
Thanks!. Once I typed something in the Combo box the drop down list appeared. But when I select something new from the drop down, it gets accumulated and the list keep getting longer and longer. please help. i just want to create only these three items only on the list.
Please Help:
You can use:
rather than AddItem
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks