AW: ToggleButton Hintergrundfarbe ändern
13.08.2019 11:40:35
Werni
Hallo Emre
Wenn die ToggelButton's eine Calclation hervor rufen, dann
Private Sub Worksheet_Calculate()
AlleTB_kontrollieren
End Sub
Und in ein normales Modul
Sub AlleTB_kontrollieren()
Dim TBs As Object
Application.ScreenUpdating = False
For Each TBs In Tabelle1.OLEObjects
If InStr(1, TBs.Name, "Togg") > 0 Then
With TBs.Name
If ActiveSheet.OLEObjects(TBs.Name).Object.Value = False Then ActiveSheet. _
OLEObjects(TBs.Name).Object.BackColor = RGB(255, 0, 0)
If ActiveSheet.OLEObjects(TBs.Name).Object.Value = True Then ActiveSheet. _
OLEObjects(TBs.Name).Object.BackColor = RGB(0, 255, 0)
End With
End If
Next
Application.ScreenUpdating = True
End Sub
Gruss Werni