I don't think you can do what you want with a Data Validation list... as far
as I know, once Edit mode has been entered, VB is inactive. The only
keyboard alternative I can offer you is to press the Alt+{DownArrow} to open
the list box associated with the Data Validation list and then arrow down to
the desired selection and then press the Enter key to confirm it (or,
instead of the Enter key, you can press Alt+{UpArrow} to simply close the
list box back up if you don't want to move to another cell for some reason).

--
Rick (MVP - Excel)


"Brad E." wrote in message
...
When I use Data Validation to limit entries in a cell (lets say I am
looking
for a day of the week), how can I let the user simply enter the letter M
to
get Monday to automatically pop into the cell, and then have to Tab or
Enter
to go to the next cell?

Also, how would Tuesday and Thursday be treated? 2 T's to get to Thursday
or TH to get Thursday?

Thank you,
--
Brad E.