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.