Real quick: AddItem with combo boxes?

  • Thread starter Thread starter AVERAGE(user)
  • Start date Start date
A

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:
 
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]...
 
combo box from control toolbar ???Forms is the one with input range and cell
link for control
--
paul
remove nospam for email addy!



Bob Phillips said:
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
Click to expand...
 
Then your code should work. Did you put the code in the worksheet code
module?

--

HTH

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