Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Adding items to a ComboBox in Excel VBA
I would like to be able to dynamically add new items to a combobox
using the contents of cells in the spreadsheet. for example, C3..C6 contain the info to be added to the combobox. Can someone tell me the code to accoplish this. I am familiar with the ComboBox.AddItem property, but I would like to populate the combobox directly from the spreadsheet. Thanks in advance to anyone. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Adding items to a ComboBox in Excel VBA
Hello Glenn
For i = 1 to 6 Combobox1.additem(worksheets("Sheet1").cells(i,3). Value Next i HTH Cordially Pascal "Glenn Speed" a écrit dans le message de om... I would like to be able to dynamically add new items to a combobox using the contents of cells in the spreadsheet. for example, C3..C6 contain the info to be added to the combobox. Can someone tell me the code to accoplish this. I am familiar with the ComboBox.AddItem property, but I would like to populate the combobox directly from the spreadsheet. Thanks in advance to anyone. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Adding Items to a ListBox-Unique Items Only | Excel Programming | |||
ComboBox Items | Excel Programming | |||
Adding Items To Active X ComboBox on Sheet | Excel Programming | |||
adding items to combobox using "Tag" control to limit | Excel Programming | |||
ComboBox items | Excel Programming |