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?
|