Word VBA (2-days)

Sponsored links

Objectives: After completing this course, you will know how to: Use VBA and examine the Visual Basic Editor; change the properties of an object; add a module to a project; write the code for a procedure and then run it; and use the Object Browser to search procedures. Manipulate data by declaring variables of different data types; combine data by using expressions; use functions to accept input and display output; and declare variables and procedures with the appropriate scope. Work with VBA objects; create, open, save, and close documents by using a Document collection; create a table by using the Tables collection; and work with the Table object. Use decision structures to create procedures that make decisions; and use loop structures to perform repetitive tasks. Add forms to a project; add controls to a form; handle events attached to forms and controls; and validate data entry in controls. Identify the compile-time, run-time, and logical errors in code; use debugging tools; and write error-handling codes to trap errors.

Prerequisites: On completion of this course, delegates will be able to create templates, update Fields, edit Macros, create User Forms, edit VBA code and build procedures, which interact with the user.

Delivery:
  • Distance
Category:

Further Details

Course Content:
Introduction To Programming
Working with Macros
Creating Sub Procedures
Calling Sub Procedures
Working With Templates
Using Templates
Creating Templates
Using Fields
Working with Variables
Declaring Variables
Initialising Variables
Editing Macros
Using Functions
Objects, Properties and Methods
Create User Forms
Working with Message Boxes
Working with Input Boxes
Evaluating a Message Box
Storing Return Values
Debugging Code
Debugging code
Setting a Watch on a Variable
Using the Intermediate Window
Error Handling
Validating User Input
Checking for Null values
Stepping through code

Guide Price: £550 per person (public course)