2 macros in a Togglebutton?

[Jorge]

Hi.

I have made 2 macros (on and off of a specific action),
and the more simple way of using them is to attach them
to a togglebuttom (if pressed down it triggers macro1,
if "depressed" or pressed up it triggrers macro 2)

How can i do this???

Thanks a lot

 

[Thomas]

With a togglebutton all you need is this in the click event of the
button:
If ToggleButton1 = True Then 'button down
Call firstmacro
Else
Call secondmacro 'button up
End If