Visual Basic for Applications is an implementation of Microsoft’s event-driven programming language Visual Basic 6, which was declared legacy in 2008, and is an associated integrated development environment.
Download Full Files
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
Source: goalkicker.com