Restricting textbox entry to a less than a given number

I have run in to a problem with a textbox. I am entering data as a number less than 6. I have the textbox set so only numbers can be entered using the following code:

Please Login or Register  to view this content.

I thought I had the problem licked with the following code:

Please Login or Register  to view this content.

The problem is when I enter the number 7, 8, or 9 my message pops up. If I enter a 10 the textbox allows the entry. What I do not know is how to get the string entered in the textbox to be seen as a number "10" not "1" and "0" which are allowed numbers. Does anyone have any suggestions?

WML0068,

In the future, please wrap your code in code tags. See forum rules (link in my sig) for how.
As for your question, attached is a sample workbook based on the criteria you described.
The workbook has one sheet that contains a button. The button is only used to launch the test userform, and it is assigned to this macro:

Please Login or Register  to view this content.

The userform only has a textbox. However, the textbox is coded to only allow any valid number less than 6. This is the complete userform code with comments:

Please Login or Register  to view this content.

Hopefully you can adapt this to fit your needs.

[EDIT]
Just realized that you don't need to use "Public frmEnableEvents". "Dim frmEnableEvents" should be just fine (and is actually recommended, I just didn't think about it when creating the sample).