Creating / Adding items to a combo box list

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..
 
B

Bob Phillips

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