Excel - Check Box Functions
Everything is possible in Excel with macros enabled.
Here's one to assign to a checkbox 1 from the Forms toolbar onto the first
worksheet:
Sub Check()
If Sheets(1).CheckBoxes(1).Value = 1 Then
Sheets(1).Range("A1").Font.Strikethrough = True
Else
Sheets(1).Range("A1").Font.Strikethrough = False
End If
End Sub
HTH. Best wishes Harald
"Mags" wrote in message
...
Is it possible to add a function to a check box so that when it's checked,
the words in an associated cell will automatically strike through?
|