Home

If Esle in VBA

Denise5552145
New Contributor

Below is my what I have coded in VBA.  I keep getting error message "Block If without End If"

Seems like this should be very simple but I'm having a problem.

Can someone help me resolve?

 

If ActiveCell = OptBtn_Q111 Then
Sheets("Audit").Range("Data_Start").Offset(TargetRow, 7).Value = "Yes"
Else
If ActiveCell = OptBtn_Q112 Then
Sheets("Audit").Range("Data_Start").Offset(TargetRow, 7).Value = "No"
Else
Sheets("Audit").Range("Data_Start").Offset(TargetRow, 7).Value = "N/A"

End If

2 Replies
To give a little more clarity, I'm using option buttons to answer questions with Yes, No, & Not Applicable,.
I've found the solution to my issue. Thanks you.
Related Conversations
Extentions Synchronization
Deleted in Discussions on
3 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
35 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
9 Replies