Can Multiple Buttons Invoke Same Event Handler?

[jdvorak]

I have 10 command buttons which all do very much the same thing, just for different cells. The interface requires that I have the 10 separate buttons. Instead of having 10 separate CommandButton_Click procedures is it possible to have all of the buttons call the same event handler in my code when any of them are clicked?

Thanks

Joe

[mdbct]

You'll still have to have the 10 separate Click events, but you can have all calling the same event.

Something like the following
In the sheet module:

Please Login or Register  to view this content.

In a standard module:

Please Login or Register  to view this content.

[Andy Pope]

If you have buttons on the worksheet then use Form Controls rather than ActiveX ones. Then you can assign the same macro to all buttons. Inside the macro use Application.Caller to determine which button was clicked.

If you have a userform or are using ActiveX controls then you can create a class with events. Create a new object for each controls and store in a collection. All buttons will trigger the same event code.

[jdvorak]

Thanks Andy. I am using a Form CommandButton. However, I can't figure out how to assign it to an event handler other than the default <CommandButton.Name>_Click. I am sure it is pretty simple. Can you tell me how to do it? Do I assign all of the buttons the same name? Thanks

Joe

[Andy Pope]

Buttons on a userform, yes?

If so see John's example
http://spreadsheetpage.com/index.php...er_dialog_box/

[jdvorak]

No, the buttons are on a worksheet

[Andy Pope]

Then select all the buttons and use the Assign Macro option on the right click menu.

[jdvorak]

Thanks Andy. This looks like it will work. Any idea how I can assign my own name to each button? The name field on the upper left of the sheet is not accepting any changes. As soon as I change it it changes back to the default name (e.g., Button16). Thanks

[Andy Pope]

Are you press enter within the name box to commit the name?

Is the new name unique? If it is one that is already in use then it will revert to original.