I realized in order to have the If Then Statements place the answers into CandidateData worksheet, then I needed to put the If Then Statements under the 'Private Sub AddUpdateCand_CommandButton_Click()' with everything else.
Is this the correct way to convert this If Then Statement?
This....
Dim score As String
score = YesRelo_OptionButton.Value
If score = True Then
Range("I37").Value = "Travel/Hotel Authorization Made" 'H
Range("N52").Value = " " 'AF
Range("N37").Value = " " 'AG
End If
End Sub
to...
If YesRelo_OptionButton.Value = True, Then .Range("H" & idx) .Value = "Travel/Hotel Authorization Made", .Range(AF & idx) .value = " ", .Range(AG & idx) .value = " " End If
Bookmarks