can I make pulldown text boxes in excel sheets

G

Guest

hi,
that is a combo box. it's in the toolbox.
tools>customize>toolbar tab>control 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.
 
Top