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
Tags:
Form / Activex Control