![]() |
Combo Box
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. |
Combo Box
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. |
Combo Box
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. |
All times are GMT +1. The time now is 12:34 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com