Microsoft Office Tutorials and References
In Depth Information
Working with Visual Basic Editor
Talkin’ the talk
Programmers have their own slang terms to
describe what they do. Here are a few:
✓ Code: The term code, which refers to the
actual instructions written in a programming
language, is always singular, like the terms
hardware and software. You don’t add
hardware s and software s to your computer
system; you add hardware and software.
Likewise, you never write or cut and paste
code you write or cut and paste code. s;
✓ GUI: The term GUI (pronounced goo -ey)
means graphical user interface. Anything
you can accomplish by using a mouse (that
is, without writing code) is considered to be
part of the GUI. You create tables, queries,
forms, reports, and macros with the GUI.
You need to write code only in modules.
✓ App: A database may be referred to as an
app, which is short for application. If a
programmer says, “I created most of the app
with the GUI; I hardly wrote any code at all,”
he means that he spent most of his time
creating tables, queries, forms, reports, and
macros by using the mouse and spent
relatively little time typing code in VBA.
The tools in the Code window are identified in Figure 1-10 and summarized
in the following list:
✦ Object box: When you’re viewing a class module, this box shows the
name of the object associated with the current code and allows you to
choose a different object. In a standard module, only the word General
appears because a standard module isn’t associated with any specific
form or report.
✦ Procedure/Events box: When you’re viewing a class module, this box
lists events supported by the object whose name appears in the Object
box. When you’re viewing a standard module, the Procedure/Events box
lists the names of all procedures in that module. To jump to a procedure
or event, just choose its name from the drop-down menu.