View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
dave caizley dave caizley is offline
external usenet poster
 
Posts: 19
Default drop down lists identifiers

Hi Bob

Thanks for the reply. Have already tried that idea but it doesnt really get
me to where I would ideally like to get to.

Thanks anyway

"Bob Phillips" wrote:

In those spreadsheets, it is likely that they are using comboboxes, not data
validation.

I just use a cell colour for the DV cells, works fine for me.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"dave caizley" wrote in message
...
In my XL2003 workbooks, I have a number of drop down lists. The small
indicator to the right only appears when I click on a cell with a list in
it.

I have seen spreadsheets where every list is permanently identifiable as
the
indicator is permanently visible.

How is this done please

Thanks in anticipation