Very neat, Dave

--
Regards
Roger Govier

"Bassman62" wrote in message
...
You can achieve this without code by creating the list of weekdays in the
cells immediately above entry cell. (The rows containing the list will be
hidden)
Set data validation for the entry cell to allow a List and set the source
as
the list of weekdays.
Hide the rows containing the list.
In Options, "Enable AutoComplete for cell values" must be checked.
With AutoComplete enabled, the user will only have to enter the first one
or
two characters of the day.
With Data Validation set, the entry will be limited to the list.

A1= Sunday
A2= Monday
A3= Tuesday
A4= Wednesday
A5= Thursday
A6= Friday
A7= Saturday
A8: [Entry Cell] (Data Validation= List of $A$1:$A$7)

Hope this helps.
Dave


"Brad E." wrote:

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.