| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
AddItem Method - Combobox value
The combobox is located on a worksheet.
ComboBox1.Clear 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" When I use the above code it prevents duplicate values because of the clear but when I select a value from the drop down it does not put the value in the combobox. The combobox is just blank. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| additem to combobox with an array | Excel Discussion (Misc queries) | |||
| AddItem Method | Excel Programming | |||
| Please help with AddItem method | Excel Programming | |||
| additem to a combobox from other excel worksheet | Excel Programming | |||
| Multiple Column ComboBox using Additem | Excel Programming | |||
Threaded Mode
