Jlamp1234
08-18-2020, 01:36 PM
Hi,
Currently I have this code:
_____________________________________________
Private Sub CheckBox95_Click()
rsp = MsgBox("Is File Location Entered in Column J?", vbYesNo + vbInformation)
If rsp = vbYes Then
rsp = MsgBox("Please Proceed to Next Step", vbInformation)
Else
rsp = MsgBox("Please Attach File Location in Column J.", vbCritical)
End If
End Sub
___________________________________
It works if the checkbox is checked and unchecked. I would like it to only work, however, if the checkbox is checked and nothing to happen when unchecked. Any advice or code?
Thank you in advance for the help!
Currently I have this code:
_____________________________________________
Private Sub CheckBox95_Click()
rsp = MsgBox("Is File Location Entered in Column J?", vbYesNo + vbInformation)
If rsp = vbYes Then
rsp = MsgBox("Please Proceed to Next Step", vbInformation)
Else
rsp = MsgBox("Please Attach File Location in Column J.", vbCritical)
End If
End Sub
___________________________________
It works if the checkbox is checked and unchecked. I would like it to only work, however, if the checkbox is checked and nothing to happen when unchecked. Any advice or code?
Thank you in advance for the help!