Find Courses Find Providers Providers - Promote Your Courses About Us

Word VBA (2-days)

Training Courses

Would you like to see more Microsoft Word courses?

Training course summary

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.
Regions:
  • All Areas
Delivery:
  • In House
  • Public
  • Computer Based
Category:
Difficulty:
  • Advanced

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)

 

Sponsored links

Interested in this course?

 

 
Information provided is for information purposes only and no guarantees are made with regards to accuracy. It is advised that all details are checked prior to making a booking. Terms of use
Website design by Brit-net