radio button help

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. Oh and the radio buttons are
the "provide_dd_yes/no/na" in the
code below.

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top