| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Auto Select from list of values
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. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Auto Select from list of values
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 "Hippy" wrote in message ... 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. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Auto Select from list of values
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. "Mike Mertes" wrote: 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 "Hippy" wrote in message ... 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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Auto Complete a select from a data validation list | Excel Discussion (Misc queries) | |||
| how do I select multi values from a list | Excel Discussion (Misc queries) | |||
| What function to select the last 3 small values from a list ? | Excel Worksheet Functions | |||
| Select values from list | Excel Discussion (Misc queries) | |||
| howto select distinct values from list | Excel Worksheet Functions | |||
Hybrid Mode
