View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
filo666 filo666 is offline
external usenet poster
 
Posts: 265
Default 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