What is Visual Basic for Applications?
Visual Basic for Applications (VBA) is a programming language built right into Access. This language is built on the Basic programming language made popular by PCs over the past 25 years. VBA shares similarities with other Windows implementations of the Basic language, such as Visual Basic. If you know how to program in Visual Basic, you will feel immediately comfortable programming in VBA. If you are familiar with programming in a different language (including using macros), you can quickly get up to speed with VBA. There are a few terms you should know before you start programming in VBA: • Procedure. A section of programming code, designed to accomplish a specific task, which your program statements can use throughout your program. There are two types of procedures: functions and subroutines. • Function. A procedure that returns a value after it completes its task. When called, functions typically appear on the right side of an equal sign in an expression. • Subroutine. A procedure