Check Box to run two macros

[Ratibor]

Hello,

I need a help. I have two macros and want to assign them to a check box. I want one macro to run when checked and the other when unchecked. I can easily assign one macro to a check box and it works when the box is checked. However I need to run another macro when the user unchecks the box. Just wondering how this is done?

I would be very grateful if someone could help me

[Ratibor]

Thank you very much. It works great

[mikekaganski]

Sub Macro(event)
  if event.Source.State = 0 then
    Macro1
  else
    Macro2
  end if
End Sub