Dim wks As Worksheet Set wks = Sheet9
If wks.Range("BO3").Offset(0, 0).Text = "Yes" Then
apeyes.Value = True
ElseIf wks.Range("BO3").Offset(0, 0).Text = "No" Then
apeno.Value = True
End If
If wks.Range("BP3").Offset(0, 0).Text = "Yes" Then
apeyes1.Value = True...