View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
tod tod is offline
external usenet poster
 
Posts: 114
Default Dropbox Question:

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
-----Original Message-----
I have validation dropbox in cell a1 and , I would like

the down arrow
icon too appear all the time not only when the user

clicks on the cell
(so there know it's there), is there any way of doing

this!?

- Fable


---
Message posted from http://www.ExcelForum.com/

.