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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

customize drop-down box 1
Drop Down with dynamic named range offsheet source list 14
Odd Drop Down Box Behavior 4
Formatted cell column in drop down list 1
How do I change contents of a cell based on drop down list selecte 2
How do I create a drop down box within a drop down box? 1
Dependent drop down dynamic range formula, off sheet. 7
data validation fonts differ in drop down box 1

Back
Top