Visual Basic for Applications (VBA) Basics («VBGLN»)

• Getting the optimum introduction to Office programming
• Applying your new skills with confidence thanks to a clear structure and systematic approach
• Gaining a solid foundation
• Translating workflows and processes into the VBA programming language to realise a high level of automation potential
• Mastering the VBA development environment and key tools for building and debugging programs

1 Introduction

• Basic terms
• Using VBA – When is VBA appropriate?
• Examples of using VBA
• Security settings
• The Visual Basic Editor

2 The Macro Recorder

• The Recorder
• Saving a macro
• Analyzing a recorded macro
• Running a recorded macro
• Fixing errors, disabling / skipping lines of code

3 VBA Basics

• Basic syntax in modules, procedures, and functions
• Upper and lower case
• The WITH keyword
• Comments
• Using variables
• Using constants
• Explicit Option
• Naming conventions

4 More VBA

• Procedures
• VBA functions
• The MsgBox
• The Direct Window
• Local and global variables
• Arrays or fields
• IF...THEN...ELSE
• SELECT...CASE
• InputBox
• Loops FOR...NEXT, WHILE...WEND, DO...LOOP
• The Project Explorer

5 Built-in VBA functions

• Text functions
• Date functions
• Mathematical functions
• Information functions
• Data type conversion

6 Error Handling

• Handling runtime errors
• Debugging

This course is aimed at power users, PC administrators and developers who want to begin automating processes in Microsoft Office applications.

No programming knowledge is required. Very good knowledge of Word and Excel is required.