Assign different macros for True/False button

[Ken G.]

I have two small macros that I want to assign to a tick box. I know how to
assign one macro, but can I assign two so that when the box is ticked it runs
one macro and when its unticked it runs the other?

 

[Jim Cone]

Assign the tickbox to a third macro...

Sub Third
if tickbox.value = true then
smallmacro1
else
smallmacro2
end if
End Sub
--
Jim Cone
Portland, Oregon USA



"Ken G." <[email protected]>
wrote in message
I have two small macros that I want to assign to a tick box. I know how to
assign one macro, but can I assign two so that when the box is ticked it runs
one macro and when its unticked it runs the other?

 

[Jacob Skaria]

Put a IF condition

If .value = True
Call Macro1
Else
Call Macro2
End If