Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I want to run a macro based on one or both value(s) of 2
checkboxes else I want to skip the macro. If chkbx1 is TRUE, I want to skip the macro. If chkbx2 is TRUE, I want to skip to skip the macro. If chkbx1 and chkbx2 are both TRUE, I want to skip the macro. This is what I have and it is not working (E6 and E7 are the cells linked to the checkbox controls.... Sub test() Worksheets("Data").Select Range("E6").Select If E6 = "TRUE" Then Worksheets("Form").Select Range("A4:I4").Select ElseIf E7 = "TRUE" Then Worksheets("Form").Select Range("A4:I4").Select Else mcrSaveAs End If End Sub Thanks for any advice you may have! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
calling macro in a formula | Excel Discussion (Misc queries) | |||
calling a dll from excel macro | Excel Programming | |||
calling a macro from within a loop | Excel Programming | |||
calling a macro from within a loop | Excel Programming | |||
Calling macro in add-in. | Excel Programming |