Hello Everyone,

I have an UserForm that loads data into the form. Then, you can update the
data. The problem that I have is that some of the textboxes are numbers and
I am doing a math check to see if it exceeds a number. What I want it to do
is: If it exceeds the value, then it returns to the Userform in the correct
textbox by using the setfocus. But, it keeps erroring out, "Invalid
Qualifier"??? The line of text is below. How can I set the focus to that
textbox BAdult???

If Val(BAdult) + Val(BChild) 12 Then MsgBox "Max people in that
section is 12!", vbInformation, "Compartment Error": BAdult.SetFocus: Exit
Sub

BAdult.SetFocus errors out!!!!

Disregard!!! Problem fixed. I forgot and left the BAdult, Dim As Integer.

"Michael Vaughan" wrote in message
...
Hello Everyone,