Difference
|
ActiveX Controls
|
Excel Controls
|
Excel versions
|
97, 2000
|
5, 95, 97, 2000
|
Which toolbar?
|
Control Toolbox
|
Forms
|
Controls available
|
CheckBox, TextBox, CommandButton, OptionButton, ListBox, ComboBox, ToggleButton, SpinButton, ScrollBar, Label, Image
|
Label, GroupBox, Button, CheckBox, OptionButton, ListBox, ComboBox, ScrollBar, Spinner
|
Macro code storage
|
In the code module for the Sheet
|
In any standard VBA module
|
Macro name
|
Corresponds to the control name (e.g., CommandButton1_Click)
|
Any name you specify.
|
Correspond to...
|
UserForm controls
|
Dialog Sheet controls
|
Customization
|
Extensive, using the Properties box
|
Minimal
|
Respond to events
|
Yes
|
Click or Change events only
|
To update on new Automation Techniques using Excel,Ms Access, SQL Server, Power BI and ASP.Net
Friday, September 20, 2013
Form Control vs. ActiveX Control in MS Excel
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment