View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Lynda
 
Posts: n/a
Default how do I make checkbox color change when the value changes?

Thank you!

"Bob Phillips" wrote:

If the checkbox is a control toolbox checkbox, use

Private Sub CheckBox1_Click()
With Me.CheckBox1
If .Value Then
.BackColor = RGB(255, 0, 0)
Else
.BackColor = RGB(255, 255, 255)
End If
End With
End Sub


--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"Lynda" wrote in message
...
I am using a checkbox. I would like the color of the check box to change
when checked. Is that possible?