Thread: Checkbox - Change color of label when clicked
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Tammy H Tammy H is offline
external usenet poster
  
Posts: 20
Default Checkbox - Change color of label when clicked
Thanks Keith! Works great.

"Keith74" wrote:

Hi

Private Sub CheckBox1_Change()
If CheckBox1.Value = True Then
CheckBox1.BackColor = RGB(0, 255, 0)
Else
CheckBox1.BackColor = RGB(255, 255, 255)
End If

End Sub

hth


Reply With QuoteReply With Quote