Hello Everyone,

I have constructed a UserForm1 with a bunch of different TextBoxes. Now, I
have it incorporated with ERROR MsgBoxes if I exceed a paramter. Now, Lets
say that I input all my data into the TextBoxes, I hit "OK" and a MsgBox
comes up saying, "You Must Enter The Fuel Burn For The Flight!".

If TextBoxFB = "" Then MsgBox "You Must Enter The Fuel Burn For The
Flight!": Exit Sub

OK.. this works fine, I hit the "OK" button on the MsgBox and I am back at
my UserForm1. NOW, the question of the day is: How do I make it so when I
hit the "OK" button on the MsgBox, it goes back to the UserForm1 with the
CURSOR blinking in the TextBox that gave me the error (TextBoxFB)???
Thanks in Advance.. mv

TextBoxFB.SetFocus
immediately before Exit Sub

HTH. Best wishes Harald

"Michael Vaughan" skrev i melding
...
Hello Everyone,

I have constructed a UserForm1 with a bunch of different TextBoxes. Now,
I
have it incorporated with ERROR MsgBoxes if I exceed a paramter. Now,
Lets
say that I input all my data into the TextBoxes, I hit "OK" and a MsgBox
comes up saying, "You Must Enter The Fuel Burn For The Flight!".

If TextBoxFB = "" Then MsgBox "You Must Enter The Fuel Burn For The
Flight!": Exit Sub

OK.. this works fine, I hit the "OK" button on the MsgBox and I am back at
my UserForm1. NOW, the question of the day is: How do I make it so when
I
hit the "OK" button on the MsgBox, it goes back to the UserForm1 with the
CURSOR blinking in the TextBox that gave me the error (TextBoxFB)???
Thanks in Advance.. mv