VBA: Events for several dynamically added buttons

Question

I am adding several CommandButtons dynamically to my user form. To assign code, I used the answer of this question: Assign code to a button created dynamically

However, I need to determine which button has been clicked. They all do have different names. Therefore, my initial idea was to get the name of the clicked button in the CmdEvents_Click() procedure. However, I have not found a solution how to do that.

Does anyone have a solution how to trigger button specific events?

It should be possible. Add the Name of the new command e.g. like```ctl_Command.Name = "name_" & i``` and then in the ```CmdEvents_Click``` just use ```CmdEvents.Name```. — Daniel Dušek, Dec 02 '15 at 14:28
if you add this as an answer, I'll give you a green checkmark :) — blckbird, Dec 02 '15 at 14:30

score 2 · Accepted Answer · answered Dec 02 '15 at 14:33

2

Add the Name of the new command e.g. like ctl_Command.Name = "name_" & i
Then in the CmdEvents_Click just use CmdEvents.Name.

answered Dec 02 '15 at 14:33

Daniel Dušek

13,316
5
34
50

VBA: Events for several dynamically added buttons

1 Answers1