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

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

Component of the following courses

• Bootcamp: Microsoft Visual Basic for Applications (VBA) («BCVBA1»)

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.

COURSE
Microsoft Excel for Power Users («MEPU»)
2 days
• Basel, Berne, Geneva, Lausanne, Virtual Training, Zürich
CHF
1'200.–
Learn more