VBA Userform - Textbox Validation

[snuffnchess]

I am trying to make it so that a client's last name cannot be blank on a userform.

I think i am close to getting it to work properly... but I keep getting a "Subscript out of range" error. Any thoughts on what I am doing wrong??

Please Login or Register  to view this content.

[jrtraylor]

Try changing to this

Please Login or Register  to view this content.

[snuffnchess]

I just changed it to that And I was able to tab through the field... never received and error and was able to save the data to the sheet... again never getting an error.

That being said, I just tested a phone number box as well, and again could tab past it without getting an error.. and saved the line item without a problem.

Please Login or Register  to view this content.

File attached here....

[mikerickson]

The AfterUpdate event fires only if the contents of the textbox are changed while it has the focus. Tabbing through the text box will not fire that event.

The verification that there is a last name should take place when the Submit button is pressed. Not as part of the textbox's event code.

[jrtraylor]

mikerickson, dumby me I did not even look at that part of the code. Mine is in the Submit Button and I knew it was working correctly so just replied quickly to try and help because I just finished setting up a userform a few minutes ago with validating 6o different textboxes.

[snuffnchess]

Got it... so when the button is pushed is when i add it in.

So the button is a "next page" button that has the following code

Please Login or Register  to view this content.

Do I just make it say

Please Login or Register  to view this content.

[snuffnchess]

I tried it and the answer is yes, except for I left out an Exit Sub.

Here is the code working in case anybody else needs it.

Please Login or Register  to view this content.