Assign different macros for True/False button
 

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?

Assign different macros for True/False button
 

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."
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?

Assign different macros for True/False button
 

Put a IF condition

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

--
If this post helps click Yes
---------------
Jacob Skaria


"Ken G." wrote:

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?