View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jim Thomlinson[_3_] Jim Thomlinson[_3_] is offline
external usenet poster
 
Posts: 983
Default combo box of control toolbox

Don't under estimate yourself. From the questions you are asking you are
picking up a lot and getting much better... Here is some code to populate a
combo box from the control toolbar...

Sub FillComboBox()
With ComboBox1
.AddItem "This"
.AddItem "That"
.AddItem "The Other"
End With

End Sub

When a combo box is added it will get the name ComboBox1 by default, so this
code should add items to the box you just added. Place this code in the the
sheet that the combo box is on. (Right click the tab and select view code.)
In the code window you have the drop down where you find General and
Worksheet. You will now have ComboBox1, and it will be associated with a
bunch of different events the same as the worksheet...

HTH

"filo666" wrote:

if I select: viewtoolbarscontrol toolbox and, when is open I take a combo
box and I put it in sheet1, how could I put the items of that comobobox?????
pd. please answerme as simple as posible because I`m new in VB