Validation - help me pls

[Guest]

With validation you get an arrow for a pull down, when you are standing in
the cell. If you not standing in this cell you do not know there is a
pulldown menu.
Does one of you know if it is possible that the arrow is shown everytime.
thnks

 

[Nick Hodge]

Not with data validation, the arrow, as you have discovered, is only visible
when the cell is selected.

If you want it the other way, you will unfortunately need to 'roll your own'
validation with comboboxes from the 'control toolbox' and write code for the
validation

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)

 

[Bob Phillips]

You could always just add a cell colour to those that you apply DV to. Not
an arrow, but visual.

--

HTH

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

 

[Dave Peterson]

I use separate colors for input cells, but maybe you could add a drawing object
(some sort of picture???) to that cell that looks like the drop down arrow.

(I'd use colors, though.)