Make a simple button behave like a toggle button?

[leonlai]

Hi, everybody

Suppose I have a simple button (not a toggle button).

I want it to run the macro "Macro1" when I click on it the first time, and run "Macro2" when I click it a second time.

If I click it a third time, it will run "Macro1" again...

I want something simple, because I will later need to translate the macros into VB .NET.

How can this be done?

Thanks.

Leon

 

[leonlai]

Re: How can we make a simple button behave like a toggle button?

Hi, Rick

What kind of button is it... one found on a UserForm or, if on a worksheet, is it a Forms button or an ActiveX button?

For the moment, I am using a Rectangular shape on my worksheet and it is assigned a macro.
I could just have used a Forms Button or an ActiveX button.

However, I just want to learn the idea, because I will ultimately convert all my VBA code to VB.NET (using Visual Studio and Add-In Express, which is similar to VSTO).

So, whether you give me the code for Rectangle, or FormsButton, or ActiveX button, will be OK for me.
It's just for learning. I will then have to adapt the idea when I develop my add-in using VB.NET.

Best Regards,
Leon

 

[leonlai]

Re: How can we make a simple button behave like a toggle button?

Hi, NdNoviceHlp

Thanks for the code. It works, and I can incorporate it in my development.

Best Regards,
Leon

 

[leonlai]

Re: How can we make a simple button behave like a toggle button?

Hi, Rick

NdNoviceHlp has already answered the question.


Best Regards,
Leon

 

[NdNoviceHlp]

Re: How can we make a simple button behave like a toggle button?

You are welcome Leon. Thanks for posting your outcome. The code posted was for a userform command button (for some unknown reason as Rick indicated) but the logic can be easily adapted for whatever similar use. Have a nice day. Dave