Thread: Check Boxes
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Shane Devenshire[_2_] Shane Devenshire[_2_] is offline
external usenet poster
 
Posts: 3,346
Default Check Boxes

Hi,

Here is the basic idea, you will need code, and you should attach it to a
Control Toolbox checkbox:

Private Sub CheckBox1_Click()
Me.CheckBox1.BackColor = RGB(0, 128, 64)
End Sub


--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"wimiko" wrote:

I have check boxes that I would like to see change color when checked. Help
please for a novice