Thread: Checkbox - Change color of label when clicked
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Keith74 Keith74 is offline
external usenet poster
  
Posts: 120
Default Checkbox - Change color of label when clicked
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