Form Control vs. ActiveX Control

[bdschleich]

I have three different options to select from, with a check box next to each item. After the user selects one of the check boxes, I want the check box to activate a macro.

I have Excel 2007 and noticed that there are two different types of check boxes - Form Control and ActiveX control. I was hoping to find out which one of these I should be using and what steps I need to complete to subsequently write the script of code needed for the macro.

Thanks!

 

[RoryA]

If you use Forms controls, you simply right-click them and choose Assign Macro. If you use ActiveX controls, you need to use the View Code button on the ribbon and put code into the Click event. I prefer the Forms controls as they are more stable in my experience unless you need the additional formatting and functional capabilities of ActiveX controls.

 

[iliace]

Form controls you can assign to any macro, whereas ActiveX controls need specific event handlers (that could also call any macro). If it's something simple, I'd go with Form controls.