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)"
wrote in message
...
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:
--------------------
Private Sub Worksheet_Activate()
dropHomeTeam.AddItem = "Minnesota Vikings"
End Sub
--------------------
Thanks
--
AVERAGE(user)
------------------------------------------------------------------------
AVERAGE(user)'s Profile:
http://www.excelforum.com/member.php...o&userid=28294
View this thread: http://www.excelforum.com/showthread...hreadid=480030