| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Check box - checked or unchecked?
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Check box - checked or unchecked?
Sorry, this refers to the check box from the control toolbox.
I am using excel 2003 "Greg Billinge" wrote: 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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Check box - checked or unchecked?
Hi Greg,
Private Sub CheckBox1_Click() If CheckBox1 Then Macro1 Else Macro2 End If End Sub Replace Macro1 and Macro2 with your macro names. --- Regards, Norman "Greg Billinge" wrote in message ... 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| sum of check boxes that have been checked | Excel Discussion (Misc queries) | |||
| Sum of check boxes that have been checked | Excel Worksheet Functions | |||
| IF checkbox is checked/unchecked, Cell.value = yes/no | Excel Worksheet Functions | |||
| Gridline box checked or unchecked. Gridlines do not print. | New Users to Excel | |||
| Print when check box checked | Excel Worksheet Functions | |||
Hybrid Mode
