Making a Field Mandatory based on a Combo Box Selection on an Excel Form

[TheKutts]

Need some assistance please. I have created an Excel Form that has a combo box field - cboCallType. One of the options in the combo box field is 'Other (Please enter details in the Notes Field). What I would like to do is to make the Notes field - txtNotes - mandatory only if the user selects '

Other (Please enter details in the Notes Field)' and not anything other option. I cannot get the code to work. Please can someone come up with the relevant code.

Thanks a lot for your help.
Regards
TheKutts
​

 

[Fluff]

Something like

   If cboCallType.Value = "Other" Then
      If txtNotes.Value = "" Then
         MsgBox "Notes cannot be empty with other"
         Exit Sub
      End If
   End If

 

[TheKutts]

Thank you very much.

Need some assistance please. I have created an Excel Form that has a combo box field - cboCallType. One of the options in the combo box field is 'Other (Please enter details in the Notes Field). What I would like to do is to make the Notes field - txtNotes - mandatory only if the user selects '

Other (Please enter details in the Notes Field)' and not anything other option. I cannot get the code to work. Please can someone come up with the relevant code.

Thanks a lot for your help.
Regards
TheKutts
​

 

[Fluff]

You're welcome