Friday, September 20, 2013

Form Control vs. ActiveX Control in MS Excel

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

No comments:

Post a Comment