2 macros in a Togglebutton?

  • Thread starter Thread starter Jorge
  • Start date Start date
J

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
 
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
 
Back
Top