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?