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.