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.
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.