Writing a macro in Excel
|
| VBA, which stands for Visual Basic for Applications, is a programming language
developed by Microsoft. Excel, along with the other members of Microsoft Office 2003,
includes the VBA language (at no extra charge). In short, VBA is the tool
that people use to develop programs that control Excel. Don’t confuse VBA with VB (which stands for Visual Basic). VB is a programming language that lets you create standalone executable programs. VBA and VB have a lot in common. If you know VB itwould be easy for you to understand and use VBA. VBA helps in "automating" tasks in Excel. This term means that a series of steps is completed automatically. For example, if you write a macro or program that adds color to some cells, prints the worksheet, and then removes the color, you have automated those three steps. Macro comes from the Greek makros, which means large. For example, you might create a VBA program to format and print your month-end sales report. After developing and testing the program, you can execute the macro with a single command, causing Excel to automatically perform many time-consuming procedures. Although Excel includes numerous built-in functions, you can create custom worksheet functions that can greatly simplify your formulas. Even better, the Insert Function dialog box displays your custom functions, making them appear built in. |
|
|
| Macros in Excel continued |