View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Harald Staff[_2_] Harald Staff[_2_] is offline
external usenet poster
 
Posts: 449
Default 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?