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-us/article/overview-of-forms-form-controls-and-activex-controls-on-a-worksheet-15ba7e28-8d7f-42ab-9470-ffb9ab94e7c2

https://stackoverflow.com/questions/15455179/what-is-the-difference-between-form-controls-and-activex-control-in-excel-20

Regards

Phil

Thank you Philip. This is a very useful sharing. 

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.

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 

Thank you Purfleet for sharing.