Quick option button question

[MWhiteDesigns]

I have an option button where its a yes or no question. If its not answered a msgbox appears. I have other check boxes and whatnot that write the value in a specific cell which is easy. But i cant determine how to write which ever option button is picked to a specific cell.

I need the a msgbox to appear if no button has been selected. Once the button is selected, i need it to go to a specific cell. Lets say (29,3).

If Me.YesOptionButton.Value = False Then
If Me.NoOptionButton.Value = False Then
MsgBox "Must Specify if attrition has been completed in HR for managers", , "HR for Managers"
Exit Sub
End If

Before there was the msgbox it showed as the below and worked fine.

If Me.YesOptionButton.Value = True Then
.Cells(29, 3) = "Yes"
End If
If Me.NoOptionButton.Value = True Then
.Cells(29, 3) = "No"

 

[CharlesChuckieCharles]

you need another End if in the top box

and the bottom box code to follow after the endif in the top box

You've sorted it

 

[MWhiteDesigns]

I was soooo close. At least I was on the right path this time. Thanks!