can I make pulldown text boxes in excel sheets
 

I want to make pulldown text boxes in excel as I do in access

Can it be done?

hi,
that is a combo box. it's in the toolbox.
toolscustomizetoolbar tabcontrol toolbox
put all of your option that will be in the combo box in a
vertical 1 column range off out of the way. say IS1:IS10
right click the combo box. click properties.
Set the ListFillRange to your options in this example it
would be IS1:IS10
Set the ListRows to 10(for this example. i don't know how
may options you are going to have.)
click exit design on the control tool box and you are done.


-----Original Message-----
I want to make pulldown text boxes in excel as I do in
access

Can it be done?
.