Dropbox Question:

[Fable]

I have validation dropbox in cell a1 and , I would like the down arro
icon too appear all the time not only when the user clicks on the cel
(so there know it’s there), is there any way of doing this!?

- Fabl

 

[Tod]

There is no way to have the arrow show all of the time.
You can add formatting around the cell, or drawn objects
to point to it. You could also insert a comment in the
cell. Or you could also have that cell become the active
cell when the sheet is activated so the user will at
least see it once. Something like this:

'Where A2 contains your Validation List
Range("A2").Select

tod