View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
ForkHandles ForkHandles is offline
external usenet poster
 
Posts: 1
Default Can the contents of a drop down box differ from what's entered?

I'm trying to figure out a way of making the content of a drop down box
differ from what is actually entreed in the cell.
For example, the drop down box contains the word "Information", but when I
select it the word "Misc Inf" is written to the cell.
I guess it's setting a range of values for the list that ultimately
reference another list.

Any help?