Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel - Check Box Functions
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel - Check Box Functions
If you have a linked cell assigned to the check box then you can use
conditional formatting to do this. Assume the linked cell is A1 and the cell to strikethrough is B1 Select cell B1 Goto the menu FormatConditional Formatting Select the Formula Is option Enter this formula in the box on the right: =A1 Click the Format button Select the Font tab Select Strikethrough OK out -- Biff Microsoft Excel MVP "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? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
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) |