Excel Macro or VBA
Excel macro programming is also known as VBA or Visual Basic for
Application. The term Macro Programming originates from Lotus 1-2-3
spreadsheet program. It was also used in the early version of Excel.
The term was gradually replaced by the name VBA. VBA is the short form
for Visual Basic for Application. VBA is different from Visual Basic.
A good Visual Basic Programmer is rarely a good VBA programmer. To
excel as a VBA programmer, the person must be conversant first in
the application Microsoft Excel
The 4 main purposes of learning VBA are to
- automate repetitive tasks and reduce the need for human intervention;
- create and add your own (customised) worksheet functions to the library of worksheet functions;
- create an interactive program that automates complex and tedious calculations in Excel;
- interact with other office applications such as Ms Word, Ms Access and MS Powerpoint.
Note: Even though VBA is a programming language, you don’t need to be
a programmer to use it.
I will provide example in this section to show you how to make use of
macros to enhance your productivity.
INTRODUCTION TO MACRO PROGRAMMING
How to record
an excel macro
In this example, we will show you how to create a macro on number formatting
by using the macro recording function provided by Excel.
Run an excel
macro using an icon
This tutorial will show you how to assign the recorded macro to
the icon and then run the macro by clicking on the icon.
Orientation
of the Visual Basic Editor where you edit your macro
This page will provide you an orienation of the editor known as
Visual Basic Editor which you will use to create, edit or manage
your macros or visual basic for application (VBA) codes.
|
