Home |
Search |
Today's Posts |
#3
![]()
Posted to microsoft.public.excel.worksheet.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? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Column Check? - Statistical functions? | Excel Worksheet Functions | |||
Increase size of a Forms Check Box (click on to enter check mark) | Excel Discussion (Misc queries) | |||
Check if Conditional Format is True or False / Check cell Color | Excel Worksheet Functions | |||
Enable check box in protected sheet + group check boxes | Excel Discussion (Misc queries) | |||
check box, so when you click on it it inserts a check mark into t. | Excel Discussion (Misc queries) |