Microsoft Office Tutorials and References
In Depth Information
Introducing the Visual Basic Editor
What You Can Do with VBA
VBA is an extremely rich programming language with thousands of uses. The following
are just a few things that you can do with VBA macros:
Insert a text string or formula. If you frequently need to enter your
company name into worksheets, you can create a macro to do the typing for you.
The AutoCorrect feature can also do this.
Automate a procedure that you perform frequently. For example, you may
need to create a series of charts to prepare a month-end summary. If the
task is straightforward, you can develop a macro to do it for you.
Automate repetitive operations. If you need to perform the same action
in 12 different charts, you can record a macro while you perform the task
once — and then let the macro repeat your action on the other charts.
Create a custom command. For example, you can combine several of Excel’s
menu commands so that they are executed from a single keystroke or from a
single mouse click.
Create a custom toolbar button. You can customize Excel’s toolbars with
your own buttons to execute macros that you write.
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.
Develop a new worksheet function. Although Excel includes a wide assortment
of built-in functions, you can create custom functions that greatly simplify your
Create complete, turnkey, macro-driven applications. Excel macros can
display custom dialog boxes and add new commands to the menu bar.
Create custom add-ins for Excel. The JWalk Chart Tools add-in (available
on the companion CD-ROM) is an example of an add-in created with VBA.
Introducing the Visual Basic Editor
Before you can begin working with VBA, you need to become familiar with the
Visual Basic Editor, or VB Editor for short. The VB Editor enables you to work with
VBA modules , which are containers for your VBA code.
Search JabSto ::

Custom Search