How to know which macro button has been selected

[tantcu]

Hi,

I have a workbook contains many macro buttons to filter data. Since there are more than 10 macro buttons, I wonder if there is a way that when you pressed a macro button, you will know that macro button is selected. Please let me know if you have a trick to do that.

Thanks

[jaslake]

Hi tantcu

I'm certainly no expert in this particular subject but, yes, there is a way to determine which Button has been selected. Are these Buttons on your Worksheet or in a UserForm?

If on a Worksheet, go into Design Mode, right click on the Button and tell me what they look like...

Do they look like this
From Form Controls.jpg

or this
From Activex Controls.jpg

[tantcu]

Hi I have something like this. I just want to know if somebody clicked on this, they know what button is clicked.Macro Button.PNG

[jaslake]

Hi tantcu

That doesn't tell us what kind of Buttons your dealing with...are they Forms Control or ActiveX Control?

If on a Worksheet, go into Design Mode, right click on the Button and tell me what they look like...

[tantcu]

It's a form control. Sorry I was not clear about this.

[jaslake]

Hi tantcu

I'm not certain what you're trying to do...play with the attached...see if it helps.