radio button help

S

sam

Hi All,

I have designed a user form in excel with radio buttons. I am trying to make
those radio buttons mandatory. Here is my code, But it doesnt work!
What happens is, If user forgets to select a radio button it pops a message
asking to select one, Once I click OK on the msgbox and then select a radio
button , It still displays the same message.

' Fee Radio button: Yes
If FeeYes.Value = True Then
ws.Cells(iRow, 17).Value = "Yes"
End If

' Fee Radio button: No
If FeeNo.Value = True Then
ws.Cells(iRow, 17).Value = "No"
End If

'check if a values is selected for Fee
If FeeYes.Value = False & FeeNo.Value = False Then
MsgBox "Please select if Fee is Reimbursed or not"
Exit Sub
End If

Please Help.



Thanks in Advance.
 
J

Jacob Skaria

AND instead of &

If FeeYes.Value = False AND FeeNo.Value = False Then
MsgBox "Please select if Fee is Reimbursed or not"
Exit Sub
End If

If this post helps click Yes
 
P

Per Jessen

Hi

You are very close, replace the '&' sign with the 'And' operator:

If FeeYes.Value = False And FeeNo.Value = False Then

Best regards,
Per
 
D

Dave Peterson

Just another thought...

If you're only allowing two choices for this option, you may want to replace the
pair of optionbuttons with a single checkbox (nicely labeled).

If you have multiple choices for this, you could always preselect (in the
userform_initialize procedure) the optionbutton that is used the most.

In either case, you'll know something was chosen--even if it was by default.
 

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