Name three reasons you must use a module rather than a macro.
What will be an ideal response?
1. Class modules are stored as part of the form or report in which they are created. If you copy the form or report, the module is contained within the object.
2. You must use modules to create unique function procedures.
3. Modules can contain procedures to mask error messages.
4. VBA works with other products in the Microsoft Office suite.
5. VBA code can contain nested If statements, Case statements, and other powerful programming code.
6. VBA can be used in conjunction with SQL to select, update, append, and delete data.
You might also like to view...
A table is a group of related fields for a single entity
Indicate whether the statement is true or false
______ is the set of hardware, software, people, policies, and procedures needed to create, manage, store, distribute, and revoke digital certificates based on asymmetric cryptography.
Fill in the blank(s) with the appropriate word(s).