About
Chapter 1: Getting started with VBA
Chapter 2: Declaring Variables
Chapter 3: Scripting.FileSystemObject
Chapter 4: Procedure Calls
Chapter 5: Naming Conventions
Chapter 6: Creating a procedure
Chapter 7: Flow control structures
Chapter 8: Comments
Chapter 9: Arrays
Chapter 10: Error Handling
Chapter 11: Recursion
Chapter 12: Conditional Compilation
Chapter 13: Data Types and Limits
Chapter 14: String Literals - Escaping, non-printable characters and line-continuations
Chapter 15: Declaring and assigning strings
Chapter 16: Converting other types to strings
Chapter 17: Searching within strings for the presence of substrings
Chapter 18: Substrings
Chapter 19: Measuring the length of strings
Chapter 20: Working with ADO
Chapter 21: Concatenating strings
Chapter 22: Assigning strings with repeated characters
Chapter 23: Scripting.Dictionary object
Chapter 24: VBA Option Keyword
Chapter 25: Date Time Manipulation
Chapter 26: Creating a Custom Class
Chapter 27: Events
Chapter 28: Attributes
Chapter 29: User Forms
Chapter 30: Object-Oriented VBA
Chapter 31: Working With Files and Directories Without Using FileSystemObject
Chapter 32: Operators
Chapter 33: Collections
Chapter 34: Passing Arguments ByRef or ByVal
Chapter 35: CreateObject vs. GetObject
Chapter 36: Macro security and signing of VBA-projects/-modules
Chapter 37: Data Structures
Chapter 38: Interfaces
Chapter 39: Reading 2GB+ files in binary in VBA and File Hashes
Chapter 40: Sorting
Chapter 41: Frequently used string manipulation
Chapter 42: Automation or Using other applications Libraries
Chapter 43: VBA Run-Time Errors
Chapter 44: Copying, returning and passing arrays
Chapter 45: Non-Latin Characters
Chapter 46: API Calls
Credits
You may also like

*The digital edition does not include access codes to additional material or programs mentioned in the book.