Chapters

Getting started with VBA

Comments

String Literals – Escaping, non-printable characters and line-continuations

VBA Option Keyword

Declaring Variables

Declaring and assigning strings

Concatenating strings

Frequently used string manipulation

Substrings

Searching within strings for the presence of substrings

Assigning strings with repeated characters

Measuring the length of strings

Converting other types to strings

Date Time Manipulation

Data Types and Limits

Naming Conventions

Data Structures

Arrays

Copying, returning and passing arrays

Collections

Operators

Sorting

Flow control structures

Passing Arguments ByRef or ByVal

Scripting.FileSystemObject

Working With Files and Directories Without Using FileSystemObject

Reading 2GB+ files in binary in VBA and File Hashes

Creating a procedure

Procedure Calls

Conditional Compilation

Object-Oriented VBA

Creating a Custom Class

Interfaces

Recursion

Events

Scripting.Dictionary object

Working with ADO

Attributes

User Forms

CreateObject vs. GetObject

Non-Latin Characters

API Calls

Automation or Using other applications Libraries

Macro security and signing of VBA-projects/-modules

VBA Run-Time Errors

Error Handling