PDA

View Full Version : VBA Checkbox Event Listener possible?



Danielm12
05-07-2015, 07:22 AM
Hi all,

I'm using ActiveX Checkboxes in my document. If a checkbox is clicked a function is executed.
I want to make it possible to insert new checkboxes in the document without writing a Sub method for that checkbox that calls my function.

Is it possible to write some kind of event listener like: "If any checkbox is clicked execute this function"? If yes, how?

Thanks in advance
Daniel

fumei
05-07-2015, 03:04 PM
ActiveX checkboxes have their own unique Sub. There is no "any" checkbox function.