ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Combo Box (https://www.excelbanter.com/excel-programming/412801-combo-box.html)

Clifford Thomas[_2_]

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.

Sam Wilson

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.


JLGWhiz

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