i use the combo box from the forms toolbar,viewtoolbarscheck forms,click on
the combo box,then click on your form,and a giant arrow will appear.If you
hover on the border you can drag its borders in the mormal windows way until
it is the size that you want.You right click on it again and select format
control,select your range for you list,you need a cell link for control of
the box,select the number of lines you want to display.I ALWAYS have trouble
finding the help infornation for this "function".There is another version of
this control but I dont use it .......I can send you a sample "from" if you
like,reply with an email address


paul
remove nospam for email addy!



"Don Guillett" wrote:

Use a box from the control or forms toolbars instead

--
Don Guillett
SalesAid Software

"Zachary" wrote in message
...
help - I have validated a cell for drop-down list, and it works great
except
that it does not show itself as a drop-down list unless the cell is
chosen.
How do I get the drop-down arrow to be seen all of the time, even when
working elsewhere in the spreadsheet? I am trying to eliminate having to
click on the cell first to choose it , then have to click on the drop-down
arrow also. I would like to be able to just click on the drop-down arrow
to
choose from list.
Can anyone help me?
--
Zachary