Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
How do I insert values or data in to the drop down list of the combo box. I
would like to know the step by step procedure. |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
if you have a combobox (call it say cmb_1) in a form then the following will
add "A new item" to its options: cmb_1.additem "A New Item" And if you wanted to add "Item 1" to "item 10" dim i as integer for i = 1 to 10 cmb_1.additem "Item " & i next i If you put this code into the form.initialize script it'll be there when you open the form. Sam "Clifford Thomas" wrote: How do I insert values or data in to the drop down list of the combo box. I would like to know the step by step procedure. |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
This site provides another method.
http://support.microsoft.com/kb/161598 You can also use the RowSource property to populate a ListBox or ComboBox. Most of these methods are described with sample code in the VBA help files. "Clifford Thomas" wrote: How do I insert values or data in to the drop down list of the combo box. I would like to know the step by step procedure. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Populate one combo box based on the selection of another combo box | Excel Programming | |||
Excel VBA Combo Box Populating dependent on other combo box choices | Excel Programming | |||
Filtered list for Combo Box ListFillRange - Nested Combo Boxes | Excel Programming | |||
"Combo Box - getting control combo box to stick in place in worksh | Excel Discussion (Misc queries) | |||
"Combo Box - getting control combo box to stick in place in worksh | Excel Discussion (Misc queries) |