View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
papou[_10_] papou[_10_] is offline
external usenet poster
 
Posts: 27
Default 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