View Single Post
  #1   Report Post  
AVERAGE(user)
 
Posts: n/a
Default Real quick: AddItem with combo boxes?


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