Can anyone help me to understand what is the function or purpose to use the ActiveX Controls in Developer tab? What is the different between Form Controls vs ActiveX Controls? attached the picture.
October 5, 2010
Both types on controls provide similar functionality : radio buttons, check boxes, lists etc.
Form Controls come as a standard part of the Excel application and have been supported from early versions. ActiveX controls are programmed as a standalone file called a DLL (Dynamically Linked Library) which are files external to Excel. You can add more ActiveX controls if you have a DLL for that control.
In general terms, Form Controls provide a base level of functionality whereas ActiveX controls allow you more flexibility in their use and configuration.
ActiveX controls are not supported on Mac.
Hard to give any more than a general answer to this question without going very much in depth. You should read more on them and certainly play aroudn with them to learn what they can do.
November 1, 2018
December 20, 2019
I have only used ActiveX controls in a few macros where i wanted the extra functionality.
Normally i would just add buttons to run a particular part of a process, but on a specific macro various people had to do their part i used ActiveX buttons so i could activate buttons after one part ran and deactivate the process that was just run.
It works really well in this case, but i wouldn't used them unless i wanted the extra functionality