recolor cell upon entry

  • Thread starter Thread starter Electric Julie
  • Start date Start date
E

Electric Julie

Is there a way to make a cell that includes a checkbox change color when the
box is checked?
 
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
 
You must log in or register to reply here.

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

Image recolor with VBA 7
PowerPoint recolor picture function 1
Recolor Cell based on Sum of Zero 1
Recoloring a special paste link from excel in powerpoint 2
Is there a way to recolor a background image with a custom color? 1
How to recolor to Black and White in PowerPoint 2007 3
Recolor a picture using VBA 3
How to recolor specific colors in a picture 2

Back
Top