Real quick: AddItem with combo boxes?

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: AVERAGE(user) <AVERAGEuser.1xllyc_1130479551.272@xxxxxxxxxxxxxxxxxxxxx>
Date: Fri, 28 Oct 2005 00:14:53 -0500

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 spread***, 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?action=getinfo&userid=28294
View this thread: http://www.excelforum.com/showthread.php?threadid=480030

.

Follow-Ups:
- Re: Real quick: AddItem with combo boxes?
  - From: Bob Phillips

Prev by Date: Re: overlaying formulas?
Next by Date: Re: Excel background picture
Previous by thread: Re: overlaying formulas?
Next by thread: Re: Real quick: AddItem with combo boxes?
Index(es):
- Date
- Thread