Gotfocus??????? [RESOLVED] ... er ... not resolved again ... :(

[Kid_Coke]

Good Afternoon All,

Here is the situation. Excel 2002 VBA Userform.

-I have 12 textboxes.
-Each has a character max of 1.
-The autotab property is set to true for all boxes.

I want the application to not allow the user to go on to the next textbox if the value is not between 1 and 5 or the number 9

If I could have used the gotfocus even I may have been able to make this work.

Any suggestions. I am really stuck.

Thanks.

Kid Coke


THE NEW PROBLEM:


Users can just press TAB or ENTER and leave the boxes empty.

Suggestions please....

KID