Form Control vs ActiveX Control
In Excel 2003
to view Form Controls toolbar: Menu: View->Toolbar->Forms
to view ActiveX toolbar: Menu: View->Toolbar->Control Toolbox
Draw a listbox from each of the toolbars
Form Control:
1. The code is always written in a general module.
2. Right Click the control and using assign macro option choose the right procedure that you want to call on the click/change in that control
To see code for form control goto FormControl module
ActiveX Control
To see code for form control goto sheet module.
While in the design mode (first button in toolbox) double-click the control to open its code window.
Comparison:
1. ActiveX controls are visually more appealing and have more formatting options available than form controls.
2. ActiveX controls trigger events while Form controls call macros assigned to them.
3. One strong reason due to which I would suggest using form controls is that sometimes events for ActiveX controls are triggered on its own when some other event is triggered.
4. At times, on opening the workbook ActiveX controls are not recognised and give errors.
Attachment | Size |
---|---|
FormControls.xls | 27.5 KB |
- Vishesh's blog
- Login or register to post comments
- 45303 reads
Recent comments
5 years 42 weeks ago
6 years 28 weeks ago
6 years 40 weeks ago
6 years 42 weeks ago
6 years 43 weeks ago
6 years 49 weeks ago
7 years 5 weeks ago
7 years 5 weeks ago
7 years 5 weeks ago
7 years 5 weeks ago