assign macro to Form Controls vs ActiveX control

[lezawang]

Hi
I can insert a Form Control and then assign Macro to it (right click, assign macro). But that is not the case with ActiveX Control. There is no "assign macro" option when you click on ActiveX Control. What is the reason behind that? Thank you.

 

[RoryA]

ActiveX controls have multiple events that you can use to run code.

 

[lezawang]

Thanks for your answer. I meant why I can not right click ActivX Control and assign Marco like Form Control?

 

[RoryA]

Because you use events, not macros, with activex controls (though you can of course call a macro from one of the events if you want).