Can the contents of a drop down box differ from what's entered?

F

ForkHandles

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

Jim Thomlinson

Generally speaking users find it somewhat disconcerting if what they entered
gets changed up on entry. You get lots of "Well thats not what I entered...".
As a suggestion use a vlookup in another cell to reference the value of the
drop down to the code you want to use. That way your user interface is simple
and intuitive and the back end uses the codes you need it to...
 
Top