Creating / Adding items to a combo box list

  • Thread starter Thread starter Ed
  • Start date Start date
E

Ed

How does one add items to a combo box list using VBA?
Basically, I need some code that will run when the xl
file opens that will populate the combo box with three
items, say "X", "Y", and "Z". All help is appreciated..
 
Ed,

With Userform1.Combobox1
.AddItem "X"
.AddItem "Y"
.AddItem "Z"
End With

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Combo box, select item, auto create another combo box in field 2
Use VLOOKUP to populate text box on form 8
Assign macro to each item of a drop-down list or combo box - how? 1
How to add an array to a combo box with Excel 2003? 8
Combo Edit box 3
Adding items to a combo box 2
Combo Box row Source 2
Combo Box Row source problem 2

Back
Top