Log In
Register
Home
Hi,
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.
Thank You,
Rgds,
CY
See Answer
October 5, 2010
Offline
Hi,
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.
https://support.office.com/en-.....b9ab94e7c2
https://stackoverflow.com/ques.....n-excel-20
Regards
Phil
Answers Post
Trusted Members
Moderators
November 1, 2018
Offline
Just my tuppence worth: don't use activex controls unless you absolutely have to. They are liable to behave strangely or stop working altogether, particularly when an Office/Windows update affects the dll that they come from.
Agreed with Velouria. After study for few round, I am still not good in using active X. 🙂 Thanks Velouria.
Trusted Members
December 20, 2019
Offline
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
1 Guest(s)
