Real quick: AddItem with combo boxes?

[AVERAGE(user)]

I'm brand new to VBA, literally picked up on it a couple minutes ago,
it's great so far, but I've ran into confusement.

I have a combo box on the spreadsheet, how do I add items to it? (not
by cell values I mean), this is what I tried:


Code:

 

[Bob Phillips]

I guess that this is a forms combo.

Private Sub Worksheet_Activate()
Activesheet.Dropdowns("dropHomeTeam").AddItem = "Minnesota Vikings"
End Sub


--

HTH

RP
(remove nothere from the email address if mailing direct)


"AVERAGE (user)" <[email protected]>
wrote in message
news:[email protected]...

 

[paul]

combo box from control toolbar ???Forms is the one with input range and cell
link for control
--
paul
remove nospam for email addy!

I guess that this is a forms combo.

Private Sub Worksheet_Activate()
Activesheet.Dropdowns("dropHomeTeam").AddItem = "Minnesota Vikings"
End Sub


--

HTH

RP
(remove nothere from the email address if mailing direct)


"AVERAGE (user)" <[email protected]>
wrote in message