View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
David Cox David Cox is offline
external usenet poster
 
Posts: 33
Default Limiting what it displayed from drop down menu

and where and when do you want the GL definitions to be able to be seen?


"Orion96" wrote in message
...
I can set up a drop down menu using validation just fine, but would like to
be able to show more information in the menu than is actually inserted
into
the cell. Is there a way to make this happen?

Ex:

The information is a list of GL codes and what expenses they represent.
While I want the user to be able to see the GL code definition, I only
want
the GL code number itself to display.

I threw this out to the best Excel developer I know and he is stumped. It
seems like this is not that unusual a need and should have a way to make
it
happen. Any advice?