Data Validation visibility

  • Thread starter Thread starter cfranz70
  • Start date Start date
C

cfranz70

Data Validation Question

I am building a spreadsheet using data validation but I would like th
drop down boxes to stay visible at all times. I have researche
thoroughly and am not aware of any way to have the icon remain visibl
unless I switch to using combo boxes. I would assume this may be don
via VBA but am not clear on the code.

Thanks for the help.

Chri
 
I don't think you could even show the dropdown arrows of a Data|Validation cell
using VBA.

I like to just color those cells a lighter shade of pale, er, yellow.

But if you don't like that, maybe you could add a comment and make sure that the
comment indicator is showing.

And if you really want, maybe you could insert a graphic from the Drawing
toolbar and have it float above those cells.
 
Back
Top