Cell with limits
 

Hi,
When somebody enters a value is a cell I want it not to be higher then (as
an example) 10 and only numbers are allowed, no other characters. If entered
a messagebox should appear saying something incorrect is entered.
What should I do??
Thanks
JP

Cell with limits
 

Hello
See Data Validation
HTH
Cordially
Pascal

"Jean-Paul De Winter" a écrit dans le message de
...
Hi,
When somebody enters a value is a cell I want it not to be higher then (as
an example) 10 and only numbers are allowed, no other characters. If
entered
a messagebox should appear saying something incorrect is entered.
What should I do??
Thanks
JP

Cell with limits
 

Hi JP,

You could use Data validation.

See Debra Dalgleish's tutorial at:

http://www.contextures.com/xlDataVal01.html

--
Regards,
Norman



"Jean-Paul De Winter" wrote in message
...
Hi,
When somebody enters a value is a cell I want it not to be higher then (as
an example) 10 and only numbers are allowed, no other characters. If
entered
a messagebox should appear saying something incorrect is entered.
What should I do??
Thanks
JP