VBA: Creating and attaching new sub to a newly created activex control?

[brucemc777]

After programmatically creating a new activex checkbox, I want to create a sub for it's click event. I have given the object a name, and fortunately the code for it's click event is a one-line call of another sub, but how???

The sub would look like the following except be named after the new control (obviously), and yes, it is just the number in the name that changes:

Please Login or Register  to view this content.

[Kyle123]

You need to create a class to listen for the events that your new control raises. Have a look here http://stackoverflow.com/questions/1...mically-in-vba

[brucemc777]

Your monkey is driving me nuts.

You got to appreciate that!