T
tjb
When the user clicks a command button, the code should
look for something in cell named "LVCHECK" if it finds
something then it should check if any of the associated
radio buttons are checked.
If they are not checked, there should be an error message
saying what the problem is and then exit the sub.
If any of them are checked it should proceed to launching
an email with the workbook attached.
Please help. Once again you all are so awesome and I
don't know what I'd do without you all!
I know this code is partly wrong but I don't see what the
problem is.
If Range("LVCHECK").Value > "1" Then
If Sheets("Request Form").provide_dd_yes =
False Then
End If
If Sheets("Request Form").provide_dd_no =
False Then
End If
If Sheets("Request Form").provide_dd_na =
False Then
MsgBox prompt:="Please answer the question in
Section 8.", Title:="ERROR"
Exit Sub
End If
Else
Application.Dialogs(xlDialogSendMail).Show _
arg1:="(e-mail address removed)", arg2:="STOP PAYMENT
OR REVERSAL for " & strSubject
Exit Sub
End If
look for something in cell named "LVCHECK" if it finds
something then it should check if any of the associated
radio buttons are checked.
If they are not checked, there should be an error message
saying what the problem is and then exit the sub.
If any of them are checked it should proceed to launching
an email with the workbook attached.
Please help. Once again you all are so awesome and I
don't know what I'd do without you all!
I know this code is partly wrong but I don't see what the
problem is.
If Range("LVCHECK").Value > "1" Then
If Sheets("Request Form").provide_dd_yes =
False Then
End If
If Sheets("Request Form").provide_dd_no =
False Then
End If
If Sheets("Request Form").provide_dd_na =
False Then
MsgBox prompt:="Please answer the question in
Section 8.", Title:="ERROR"
Exit Sub
End If
Else
Application.Dialogs(xlDialogSendMail).Show _
arg1:="(e-mail address removed)", arg2:="STOP PAYMENT
OR REVERSAL for " & strSubject
Exit Sub
End If