Thread: Combo Box
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Sam Wilson Sam Wilson is offline
external usenet poster
 
Posts: 523
Default 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.