Check box - checked or unchecked?

G

Greg Billinge

Hi,

I have a check box (eg: checkbox1), That, when checked i want to run some
code i already have. When it is unchecked i want it to run some different
code.

Any help is much appreciated.

Many thanks

Greg
 
G

Greg Billinge

Sorry, this refers to the check box from the control toolbox.

I am using excel 2003
 
N

Norman Jones

Hi Greg,

Private Sub CheckBox1_Click()
If CheckBox1 Then
Macro1
Else
Macro2
End If
End Sub

Replace Macro1 and Macro2 with your macro names.
 
Top