ActiveSheet (IF statement)

[hmaze]

All:

I have a form that needs to appear after a togglebutton has been activated
on sheet1 and the user clicks on sheet2. I need the form to appear on
sheet2. (if toggle not clicked and user goes to sheet2, form should not
appear). I tried this on sheet1 but it's not correct:
If ToggleButton1.Value = True And ActiveSheet = Sheet2 Then UserForm1.Show

Can anyone provide some assistance - thank you.

 

[JLGWhiz]

How about a Worksheet_Activate event in the Sheet2 code module that checks
toggle button 1 for true and then call the form?

 

[JLGWhiz]

Assumes that ToggleButton1 is located on Sheet1.

Private Sub Worksheet_Activate()
If Sheets(1).ToggleButton1 = True Then
UserForm1.Show
End If
End Sub

 

[JLGWhiz]

sorry about the omission.

Private Sub Worksheet_Activate()
If Sheets(1).ToggleButton1.Value = True Then
UserForm1.Show
End If
End Sub

 

[hmaze]

That's it - thank you!

sorry about the omission.

Private Sub Worksheet_Activate()
If Sheets(1).ToggleButton1.Value = True Then
UserForm1.Show
End If
End Sub