Hi - New to the forum.

I have the VBA sub below. I can't seem to get it to pass the state of CheckBox9 (which is alway "False"). Can anyone help. please.

Private Sub CheckBox9_Click()
'
' Macro1 Macro
'
Dim aa As Boolean


If CheckBox9 = True Then
ActiveSheet.Tab.ColorIndex = 35
Else
'If CheckBox9 = False Then
ActiveSheet.Tab.ColorIndex = 15
End If


'
End Sub