recolor cell upon entry

E

Electric Julie

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

Sheeloo

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Force Greyscale on certain Pages in Pub 2016 0
Visio shape text disappears upon copy paste 1
Recover Outlook calendar entry 1
PowerPoint recolor picture function 1
How to create bulleted to-do list using two styles? 5
Is there a way to recolor a background image with a custom color? 1
How to Turn off Automatic Recoloring 3
list or combo box 0

Top