I created a userform in Excel VBE. When the user form is active I have a couple of option buttons that I need to use. One is to disable the userform from showing. Basicaly show the userform unless option 1 is true so that I can run another
macro I recorded on the spreadsheet. The Convert Macro only runs if I need to convert the numbers to USD currency. I am new to VBA coding so not really sure how to get this done. Any help would be greatly appreciate. I need to stop the 2nd IF statement below from happening if option 1 is pressed.


Here is the code I have to activate the userform:

Private Sub Worksheet_SelecttionChange(ByVal Target As Range)
If Not Intersect(Target, Me.Range("A1,A3,G3")) Is Nothing Then
CusName.Show
Else
End If

If Not Intersect(Target, Me.Range("C4,C7:C23,C39,C40,C42,C46,E4,E7:E23,E39,E40,E42,E46,G4,G7:G23,G39,G40,G42,G46,C75:C133,D75:D133,E75:E133,F75:F133,G75:G133")) Is Nothing Then
FinancialInfo.Show

End If
If ForeignOpt_Click = True Then
FinancialInfo.Hide
End If

End Sub