msgBox problem

It would help if you told us what line of code you are getting the error on

Instead of the following command (which I am assuming is causing your problem)

TextBox2.Activate

You are probally wanting

TextBox2.SetFocus

What is the purpose of this command

TextBox2.Value = TextBox2.Text

TextBox2.Value is already the same as TextBox2.Text

Originally Posted by bernie1961

I am trying to have a message box show when a user fails to fill in a required text box in a user form, however the box does not pop up and I am getting no error messages as to an incorrect code. Here is what I'm using:

Private Sub TextBox2_LostFocus()
    If TextBox2.Value = vbNullString Then
         'TextBox2.Value is empty then show msgbox
         MsgBox "TextBox2 value is required.", vbCritical, "Required Value"
         TextBox2.Activate
       Else
        TextBox2.Value = TextBox2.Text

    End If
End Sub

Thanks for any feedback!
Bernadette

Hi Bernadette,
The msgbox works if you use the exit
Private Sub TextBox2_Exit(ByVal Cancel As MSForms.ReturnBoolean)