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

Its a bit convoluted but weve cracked it. Link the combo box to a cell and it
places a value in that cell. Use that number to create the argument in the
formula

"dave caizley" wrote:

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