Display a message

[Ridhi]

Is there any way to display a mesage if wrong value is entred in the cell.

Can we restrict a user to enter only a numeric value in a cell which is with
in a certain range like value between "3-8" or alphabets only.

Please help

 

[Jarek Kujawa]

go to Data->Data validation, choose last posiotion on the list
(Userdefined or non-standard, am not sure)

in formula window put the following:

AND(A1>=3,A1=<8)

for "alphabets" use:
=OR(AND(CODE(A1)>=65,CODE(A1)=<90),AND(CODE(A1)>=97,CODE(A1)=<122))

 

[Ridhi]

Thank for your reply ..but can u please expalin me the code you have
written,what does"Code"here stands for?

Please explain in detail.

Regards
Ridhi

 

[Ridhi]

but we cannot make user enter a value in a cell which already contains a
formula.

 

[Jarek Kujawa]

This function shows the ANSI value of a single character, or the first
character in a piece of text. The ANSI character set is used by
Windows to identify each keyboard character by using a unique number.