Im voraus besten Dank
WernerH
Function SummeFett(Bereich As Range) As Variant
Dim i As Range
Application.Volatile
For Each i In Bereich.Cells
If i.Font.Bold Then
SummeFett = SummeFett + i
End If
Next
End Function
Private Sub ToggleButton1_Click()
If stopp Then Exit Sub
If ToggleButton1 Then
ToggleButton1.Caption = "Fett"
Else
ToggleButton1.Caption = "schlank"
End If
Selection.Font.Bold = ToggleButton1
End Sub
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Dim c As Range
Set c = ActiveCell
stopp = True
If c.Font.Bold Then
ToggleButton1.Caption = "Fett"
Else
ToggleButton1.Caption = "schlank"
End If
ToggleButton1 = c.Font.Bold
stopp = False
End Sub