Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA for put cell C2 in overstrike/black when B2 checkbox is ticked?
I was thinking that it would help with a list I have if I added a
column with a checkbox that, once ticked, would put contents in cell to the right of it in list, in overstrike and black (as the font is coloured to begin with). How would one go about that? Tx! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA for put cell C2 in overstrike/black when B2 checkbox is ticked?
Private Sub Checkbox1_Click()
Dim rng as Range set rng = me.OleObjects("CheckBox1").TopLeftCell if checkbox1.Value then With rng.offset(0,1).Font .StrikeThrough = True .ColorIndex = xlAutomatic End With else With rng.offset(0,1).Font .StrikeThrough = False .ColorIndex = 3 End With End if End Sub -- Regards, Tom Ogilvy "StargateFan" wrote in message ... I was thinking that it would help with a list I have if I added a column with a checkbox that, once ticked, would put contents in cell to the right of it in list, in overstrike and black (as the font is coloured to begin with). How would one go about that? Tx! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
is there a way to overstrike characters in excel | Excel Discussion (Misc queries) | |||
Allowing only 1 check box to be ticked | Excel Discussion (Misc queries) | |||
CheckBox Ticked, ComboBoxBox visible? | Excel Discussion (Misc queries) | |||
Math formulas possible with overstrike characters? | Excel Discussion (Misc queries) | |||
get a list of ticked add-in | Excel Worksheet Functions |