Restricted Entry into a cell.

chriscousins

New Member
Joined
Dec 2, 2005
Messages
43
Hi guys.
Great Board...used it regularly for help.
This is my first question...

I need to restrict entry to a cell to any numeric value plue allow "r" "s" "h" and "a" as well (as well as the upper case of the letters)

I want to delete any entry other than those allowed, and have nearly managed it using target.value and case to select the allowed letters, but how do I allow the numbers as well as the 4 letters.

Hope you understand what I'm trying to acheive.

Help appreciated. :biggrin:
 

Some videos you may like

Excel Facts

Format cells as date
Select range and press Ctrl+Shift+3 to format cells as date. (Shift 3 is the # sign which sort of looks like a small calendar).

mightymishra

Board Regular
Joined
Oct 18, 2002
Messages
65
one quick thing i managed
i tried to do this validation in cell G11

In Data>Validation
under Settings tab
Allow Custom
Formula =OR(ISNUMBER(G11),CODE(LOWER(G11))=104,CODE(LOWER(G11))=114,CODE(LOWER(G11))=115)
 

Watch MrExcel Video

Forum statistics

Threads
1,118,673
Messages
5,573,594
Members
412,537
Latest member
Mohamed_5966
Top