Difference Between Form Controls Vs Activex Control ?

Ans :

⚝ A) Form Controls :

➀ Form Controls are the built-in feature in Excel

➁ They are much simpler

➂ Form control feature is available both in Windows and Mac

➃ Can not be used as an object in codes

➄ The functionality of the Form Control cannot be extended

➅ Form Controls don't have any properties settings

➆ Excel response to the Form control, after every updating or editing on it

⚝ B) Activex Controls :

➀ ActiveX Controls sometimes need to be added manually by the user

➁ They have a more flexible design than Form Control

➂ Not available in Mac

➃ Can be used as objects in codes

➄ These are generated from DLLs. By using the Register Custom under More Controls, you can extend
the functionality of the ActiveX controls.

➅ ActiveX Control has properties settings

➆ The response to the ActiveX control in Excel is continuous

Post a Comment

Previous Post Next Post