VBA for Word
Duration - 2 days
Prerequisites
- skills to MS Word Advanced level
Course Content:
- Understand the Word object model and VBA concepts
- Work efficiently with the main features of the VBA Editor window
- Create procedures in VBA
- Create and use variables
- Create and work with user-defined functions
- Use programming techniques to control the action taken by your program
- Construct a variety of loops
- Identify and select text using code
- Create and use code to undertake basic file management tasks
- Create a custom form with controls
- Create code to drive a user form
- Write a variety of error handling routines
- Use VBA to display Word’s built-in dialog boxes
VBA for Excel
Duration - 2 days
Prerequisites
- skills to MS Excel Advanced level
Course Content:
- Create recorded macros in Excel
- Use the macro recorder to create a variety of macros
- Understand the Excel object model and VBA concepts
- Work effectively with the main features of the VBA Editor window
- Create procedures in VBA
- Create and use variables
- Create and work with user-defined functions in VBA
- Write code to manipulate Excel objects
- Use a range of common programming techniques
- Create a custom form with controls
- Create code to drive a user form
- Create procedures that start automatically
- Write a variety of error handling procedures
VBA for Access
Duration - 2 days
Prerequisites
- skills to MS Access Advanced level
Course Content:
- Understand some of the aspects of developing applications in Access
- Use macros in Access
- Understand the programming environment and how forms and modules are used in it
- Create and work with subroutines and function procedures
- Create and work with variables
- Create input and message boxes
- Program decision structures using IF and Case statements
- Develop a variety of loops
- Use the DoCmd object
- Use DAO and ADO for working with data
- Use the debugging features of VBA to locate and identify errors
- Develop safeguards in your program and prevent unforeseen errors