showing dropdown selection arrows in spread sheets
 

I have figured out how to build dropdowns. now I would like to have the
selection arrows show all the time instead of when you mouse over. Anyone
know how to do that, if it's possible?
--
RGGSR

showing dropdown selection arrows in spread sheets
 

You can't with Data Validation. You could either colour the cell as well, or
switch to a combobox.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"rongripon" wrote in message
...
I have figured out how to build dropdowns. now I would like to have the
selection arrows show all the time instead of when you mouse over. Anyone
know how to do that, if it's possible?
--
RGGSR

showing dropdown selection arrows in spread sheets
 

You'd have to switch from using the Data, Validation list feature to using a
combo box from the Forms toolbar.

--
Jim
"rongripon" wrote in message
...
|I have figured out how to build dropdowns. now I would like to have the
| selection arrows show all the time instead of when you mouse over. Anyone
| know how to do that, if it's possible?
| --
| RGGSR