Microsoft Office Tutorials and References
In Depth Information
Introducing the Visual Basic Editor
Introducing the Visual Basic Editor
Understanding a concept begins with defining unfamiliar terms. The
terminology required to understand Visual Basic for Applications (VBA) is
fairly straightforward and is introduced throughout the book. In order to start
learning, you need to become familiar with the following terms:
Int
Term
Description
Code
This term is generally used to refer to the text of the program
language.
Visual Basic for
Applications (VBA)
The programming language used to write programs in
Microsoft Office applications.
Visual Basic Editor
(VBE)
The environment (or window) in which VBA code is written.
Procedures
Entities that perform a task and in which the code is written;
also called macros. Think of them as containers for code.
Modules
A container for Procedures. A Module can hold many
Procedures or just one.
Projects
A container for modules. All of the VBA code in any single
workbook, document, database, presentation, or Outlook item
is called a project.
Comments/
Commented Code
This is a part of the code that is preceded by special
characters so that it is seen as text and will not run. Placing
an apostrophe as the first character of the line “tells” VBA
that this line is a comment.
Good coders heavily comment their code so that it can be
more easily edited when necessary.
Add-ins
When a Microsoft Office program opens, any installed add-
ins also open. Add-ins are special programs that extend the
built-in features of the program in some way.
Thus, there are sometimes more objects open within the
application environment than you might think. Not all of
these objects have a visible presence in the standard
interface, but they are all at least partially exposed in the
programming environment.
 
Search JabSto ::




Custom Search