Combo Box easy

[WorkinOnIt13]

<font color=Blue>What is the easiest way to do a combo box in Excel 2003? I have bee playing with my VB, but for some reason the code is not working, and when it does, I click on an item in the combo box and next thing you know, all the items have doubled or tripled...Any suggestions...? Thanks guys! Been awhile since I have been on here..! =)</font>

 

[Legacy 51064]

Will you be able to post your code?

 

[Joe Was]

Which ComboBox Excel has different types each is coded differently!

 

[WorkinOnIt13]

I got it....without code

<font color=Red>I think I may have figured it out. What I did was just right clicked on the toolbars, selected forms and edited a combo box from there! Really the only reason I need it is to show where meetings will be scheduled on an excel Calendar! So there is no referencing cells to anything! Thanks for the thought though.... I was using the basic

This was the code in VB.....looks right to someone who is not well trained like me....</font>
<font color=Blue>
Private Sub cbo2_Load()
cbo2.AddItem "CONSTITTUTION", 0
cbo2.AddItem "COBBLESTONE"
cbo2.AddItem "ANNEX II"
cbo2.AddItem "SCOWCROFT A"
cbo2.AddItem "MILLSTREAM"
cbo2.AddItem "WEBER ROOM"
End Sub</Font>