How to keep the drop down arrow on data lists when not selected?

D

Diamondgirl

I have data validations set up in a worksheet, and I want to be able to tab
off the lists, and yet still have the arrows viewable. Is this possible to
do so?
 
T

T. Valko

If you use a combo box from the Forms toolbar the drop arrow is always
visible however, a combo box acts a bit differently than a data validation
drop down list. If you use the selected item in formulas then it's slightly
more complicated but simple once you learn how to do it.
 
D

Diamondgirl

Darn... not quite what I wanted to hear, but I'll try it. Yes, these are
pretty basic lists; therefore the combo box might have to be the trick.
Thank you for your quick response!
 

Ask a Question

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.

Ask a Question

Top