Hi,
I created a toggle button to show or hide text:
Private Sub ToggleButton1_Click()
If ToggleButton1.Value = True Then
'This area contains the things you want to happen
'when the toggle button is not depressed
Range("b7:d8").Font.Color = RGB(0, 0, 0)
Else
'This area contains the things you want to happen
'when the toggle button is depressed
Range("b7:d8").Font.Color = RGB(252, 228, 214)
End If
End Sub
It's maybe not the best way to make text invisible, but I would like to add another task: toggling between =SUM(B3:B26)-B7-B8 in cell B27 & =SUM(B3:B26)
Can I do it?
Thanks,
dbuff
Bookmarks