Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
combo box of control toolbox
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
combo box of control toolbox
thnaks, you are my favorit MVA teacher, at what hour you are in the net????
"Jim Thomlinson" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
what is code to activate a combo box in control toolbox | Excel Discussion (Misc queries) | |||
combo box from control toolbox | Excel Discussion (Misc queries) | |||
control toolbox combo box | Excel Discussion (Misc queries) | |||
Mystery of the moving control toolbox combo box? | Excel Programming | |||
No change event on control toolbox combo box when selection is the same? | Excel Programming |