Microsoft Office Tutorials and References
In Depth Information
Learning about Macros and VBA
h Respond to events automatically: You can create macros that execute automatically
when a particular event occurs. For example, you can write a macro that responds to the
WorksheetChange event — which is triggered whenever a cell in a worksheet is changed.
Excel supports many other events.
h Create a simplified “front end” for users who don’t know much about Excel: For
example, you can set up a foolproof data entry template.
h Develop a new worksheet function: Although Excel includes a wide assortment of
builtin functions, you can create custom functions that can greatly simplify your formulas.
h Create complete, macro-driven applications: Excel macros can display custom dialog
boxes and be executed from commands you add to the Ribbon.
h Create custom add-ins for Excel: Most add-ins that are shipped with Excel were created
with Excel macros.