Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
AddItem Method
Private Sub ComboBox1_DropButtonClick()
ComboBox1.AddItem "Jan Week 1" ComboBox1.AddItem "Jan Week 2" ComboBox1.AddItem "Jan Week 3" ComboBox1.AddItem "Jan Week 4" ComboBox1.AddItem "Jan Week 5" ComboBox1.AddItem "Jan MTD" End Sub hey guys The above code adds the specified values to ComboBox1 when a user clicks the drop down box on the combobox. Problem is when the user clicks the dropdown button again, the values are added again so now there are 2 sets of the same values. If the user clicks it again, a 3rd set is listed and so on... How do I prevent these values from adding up? Thank you TOdd Huttenstine |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Please post this thread a correct full method, method about | New Users to Excel | |||
Help with: ListBox1.AddItem (ws.Name) | Excel Worksheet Functions | |||
Please help with AddItem method | Excel Programming | |||
.additem | Excel Programming | |||
additem listbox | Excel Programming |