Auto Select from list of values

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

Guest

Is there a way to automatically populate a cell in Excel with a value from a
list of values. For example my list of values contains cat, dog and pig. when
the user is in the field they entere a "d" and dog is automatically selected.
 
If your purpose is simply to supply the user with an easily accessable list
of selectable items, validation lists are probably your best bet.
Unfortunately it seems you have to activate and then choose with the mouse
your selection. If that's not a problem, check out data validations.

-Mike
 
Can something be set up so that if the user enters a blank cell that has a
list of values the list would pop up automatically and not give them the
ability to type in the cell.
 

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

excel sheet with control combobox 3
One sheet to another.. 3
Top 5 most recurrent values in range. 8
Cell Validation 1
Searching multiple fields and then print the entire row from resul 1
Quick Macro Needed 8
selecting cells and getting their content into a string? 1
Dialog Box returning Array Value instead of Actual List Value 3

Back
Top