VBA to Enable/Disable Toggle Button

[Scuba94]

Hello,

I have a working toggle button (names 'RevealCharges') that may or may not be used by the user i.e. sometimes its on, sometimes the user doesn't select it, if its selected it unhides certain rows of data.
I also have another field in excel (named 'CFS_or_CY_Loading') that has a drop down list with 2 options, for simplicity, lets say its 'On' & 'Off' as the 2 options

What I would like to do is, if the toggle button is 'On' and named field 'CFS_or_CY_Loading' is change from 'On' to 'Off', then toggle button 'RevealCharges' is forced to a 'False' status, which means the certain rows are hidden again.

Bassically what I have is , if the Toggle button is 'On' then it is stopping other VBA rules from running, until such time as its tuned 'Off', hence the above question.

I woudl be most appreactive if anyone can offer any help/guidance?

Regards
Richard

 

[Logit]

Paste in the SHEET module :

Option Explicit

Sub ToggleButton1_Click()

With Me.ToggleButton1
If .Value = False Then
   .Caption = "OFF"
   'Your OFF code here
Else: .Caption = "ON"
    'Your ON code here
End If
End With

Sheets("Sheet1").Range("A1").Value = Me.ToggleButton1.Caption
End Sub

 

[Scuba94]

Paste in the SHEET module :

Option Explicit

Sub ToggleButton1_Click()

With Me.ToggleButton1
If .Value = False Then
   .Caption = "OFF"
   'Your OFF code here
Else: .Caption = "ON"
    'Your ON code here
End If
End With

Sheets("Sheet1").Range("A1").Value = Me.ToggleButton1.Caption
End Sub

thank you