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)
 
Back
Top