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.
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.