View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Norman Jones Norman Jones is offline
external usenet poster
 
Posts: 5,302
Default 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