C Clifford Thomas Jun 19, 2008 #1 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.
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.
S Sam Wilson Jun 19, 2008 #2 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
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
J JLGWhiz Jun 19, 2008 #3 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.
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.
