Check UserForm Values Before Saving
Excellent help, many thanks for the replies. I have amended the code to
include an Exit Sub after each check, all works fine now.
Regards,
Mickey
=============================================
If ComboBoxPIN.Text = "" Then
MsgBox "You Must Enter a PIN Number."
ComboBoxPIN.SetFocus
Exit Sub
ElseIf ComboBoxDate.Value = "" Then
MsgBox "You Must Enter a Date."
ComboBoxDate.SetFocus
Exit Sub
etc ..........
|