userform - user must enter name to begin

[ajm]

Hi, how do i set up a userform to make users enter their name before they can proceed? I don't want to use an inputbox before the form is called as the form is meant to help them save time while answering telephone calls. Currently, their is just a text box for them to input their name but most don't. this makes tracking who made what changes difficult.

 

[DanteAmor]

If you have a button in the userform to save the data on the sheet, there you can put the following:

Private Sub CommandButton1_Click()
  If TextBox20 = "" Then
    MsgBox "Enter your name", vbCritical, "SAVE DATA CANCELED"
    TextBox20.SetFocus
    Exit Sub
  End If
  '
  'Continue your code to save the data on the sheet.
  '
End Sub

 

[ajm]

If you have a button in the userform to save the data on the sheet, there you can put the following:

Private Sub CommandButton1_Click()
  If TextBox20 = "" Then
    MsgBox "Enter your name", vbCritical, "SAVE DATA CANCELED"
    TextBox20.SetFocus
    Exit Sub
  End If
  '
  'Continue your code to save the data on the sheet.
  '
End Sub

cheers Dante. that should do the trick nicely. I have a button to add the data to the report so will put your snippet in. Fantastic.

 

[DanteAmor]

I'm glad to help you. Thanks for the feedback.