View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
MBlake[_2_] MBlake[_2_] is offline
external usenet poster
 
Posts: 35
Default 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 ..........