Cell with limits

  • Thread starter Thread starter Jean-Paul De Winter
  • Start date Start date
J

Jean-Paul De Winter

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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

code to dis[play a message if the active cell contains an asteric 2
Text Formats 4
Excel VBA to move cursor from 1 cell to another, once original cell is filled with data. 3
Code character limit with Resize or Transpose or cell? 8
Loop help 5
Changing a cell colour if target not met. 4
Msgbox if cell is not a value 4
Lock different ranges after inserting data 4

Back
Top