Drop-down arrow only visible when cell selected

J

John Richards

Hi all,

I created several drop-down lists using Data, Validate,... The drop-down
arrows are not visible unless the cells are selected. Is this the default
and can it be changed or am I stuck with the "invisible" drop-downs? I
would like to have all the drop-down arrows visible at all times so it will
be obvious to a user that they will be using drop-downs.

I was also wondering if a drop-down can be disabled ("grayed out") as a
result of a conditional test?

Thanks
John
 
B

Biff

Hi!

You can use a combobox from the Forms toolbar. The arrow
is always visible.

For your second question, that would probably be possible
using a combobox from the Control Toolbox but would also
require VBA programming. I can't help you with that.

Biff
 
B

Bob Phillips

John,

That is the way that Data Validation works. Rather than lose the convenience
of DVs, why not just colour the DV cells?

You could then use conditional formatting to un-colour them if another cell
meets a condition.event

--

HTH

RP
(remove nothere from the email address if mailing direct)
 

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

Similar Threads

Data Validation and drop-down list using IF, AND and what else? 8
Hide drop downs 1
Help needed with unique numbers and multiple concatanated drop downsplease 5
drop-down menus in Excel 2003 not working 3
Drop Down with dynamic named range offsheet source list 14
Drop-down list vanished & won't come back 4
Dependent drop down dynamic range formula, off sheet. 7
drop down lists 1

Top