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:

Please Login or Register  to view this content.

Thanks

[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]...
>
> 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
>

[paul]

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" wrote:

> 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]...
> >
> > 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
> >
>
>
>

[Bob Phillips]

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)


"paul" <[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" wrote:
>
> > 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]...
> > >
> > > 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
> > >
> >
> >
> >