Check box - checked or unchecked?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Sorry, this refers to the check box from the control toolbox.

I am using excel 2003
 
Hi Greg,

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

Replace Macro1 and Macro2 with your macro names.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Check Box Help 4
check/uncheck a checkbox 3
Linking textboxes with option boxes 4
Check Box Show Hide 1
Control checkboxes 1
Loop for check boxes 4
Check box counting 7
Form Control vs. Active X Controls 7

Back
Top