Bassman62;243145 Wrote:
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.

Nice solution Bassman62!


--
Leith Ross

Sincerely,
Leith Ross

'The Code Cage' (http://www.thecodecage.com/)
------------------------------------------------------------------------
Leith Ross's Profile: http://www.thecodecage.com/forumz/member.php?userid=75
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=67605