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

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

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)"
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

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" wrote in message
...
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)"

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