recolor cell upon entry
 

Is there a way to make a cell that includes a checkbox change color when the
box is checked?

recolor cell upon entry
 

If you know the cell address (P10 in this code) then you can do the following
in the click event for chkbox Ck1;
Private Sub Ck1_Click()
Range("P10").Select
With Selection.Interior
.ColorIndex = 36
.Pattern = xlSolid
End With
'Selection.Font.ColorIndex = 46
'Selection.FormulaR1C1 = "Test"
End Sub
--
Always provide your feedback...


"Electric Julie" wrote:

Is there a way to make a cell that includes a checkbox change color when the
box is checked?