i want to validate two cells

first one: only alphabet a-z A-Z

second one: it should be a number but it can have a
decimal place 0-9 & .

i want a MsgBox "error" to appear if the user enters in
something not valid.

how do i validate these? pleaaaase help!

Use data validation.

Jake Marx just posted this formula in response to a similar posting:

=25*LEN(A1)=SUM(LEN(SUBSTITUTE(UPPER(A1),CHAR(ROW( $A$65:$A$90)),"")))
(this is an array formula, but used in validation, it should require any
special attention (untested). )

for the second, use the build in choice of decimal and specify your bounds.
Your statement of the restriction sounds like it can be a decimal number.
If it is more restrictive than that, then you have not stated that clearly.

--
Regards,
Tom Ogilvy

wrote in message
...
i want to validate two cells

first one: only alphabet a-z A-Z

second one: it should be a number but it can have a
decimal place 0-9 & .

i want a MsgBox "error" to appear if the user enters in
something not valid.

how do i validate these? pleaaaase help!

hello,

i don't understand what this formula does?? can someone
please explain! :(

-----Original Message-----
Use data validation.

Jake Marx just posted this formula in response to a
similar posting:

=25*LEN(A1)=SUM(LEN(SUBSTITUTE(UPPER(A1),CHAR(R OW
($A$65:$A$90)),"")))
(this is an array formula, but used in validation, it
should require any
special attention (untested). )

for the second, use the build in choice of decimal and
specify your bounds.
Your statement of the restriction sounds like it can be a
decimal number.
If it is more restrictive than that, then you have not
stated that clearly.

--
Regards,
Tom Ogilvy

wrote in message
...
i want to validate two cells

first one: only alphabet a-z A-Z

second one: it should be a number but it can have a
decimal place 0-9 & .

i want a MsgBox "error" to appear if the user enters in
something not valid.

how do i validate these? pleaaaase help!


.