View Single Post
  #7   Report Post  
George Nicholson
 
Posts: n/a
Default Show Drop Down Arrow

You could add a narrow column to the right of your data validation and copy
an appropriate "down pointing" VCR-type arrow symbol from Character map
(StartProgramsAccessoriesSystemToolsCharacterM ap).
..
When the data valadation cell is selected the "real" arrow will appear
rather than your added symbol.

There are drawbacks to this approach, but it clearly indicates where
dropdowns reside. It can work rather nicely if you have a vertical list of
inputs rather than horizontal.

HTH,
--
George Nicholson

Remove 'Junk' from return address.


"travelersway"
wrote in message
news:travelersway.1x20ei_1129565148.8955@excelforu m-nospam.com...

Thank you Dave Peterson, but I'd like to show the drop down window with
the arrow so it is obvious what it is, a list to make a selection.


--
travelersway
------------------------------------------------------------------------
travelersway's Profile:
http://www.excelforum.com/member.php...o&userid=17623
View this thread: http://www.excelforum.com/showthread...hreadid=476747