I have an Excel form and before it passes the data back to the worksheet, I
want to confirm that the user has entered a number into the field and that
the number is within a certain range...any ideas on how to do that?

Even better would to confirm the data when they leave the field.

Thanks.