VBA Notes for Professionals book

VBA Book preview
VBA Notes for Professionals book

If you found this free VBA book useful,
then please share it ❤

Chapters

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

Example book pages

VBA Example Page 1VBA Example Page 2
VBA Example Page 3VBA Example Page 4

What people are saying about Notes for Professionals books

The VBA Notes for Professionals book is compiled from Stack Overflow Documentation, the content is written by the beautiful people at Stack Overflow. Text content is released under Creative Commons BY-SA. See credits at the end of this book whom contributed to the various chapters. Images may be copyright of their respective owners unless otherwise specified

Book created for educational purposes and is not affiliated with VBA group(s), company(s) nor Stack Overflow. All trademarks belong to their respective company owners

202 pages, published on June 2018

Sign up for changes to VBA Notes for Professionals book

DotNETFramework Book
C Book
CSharp Book
CPlusPlus Book
EntityFramework Book
ExcelVBA Book
MicrosoftSQLServer Book
SQL Book
VisualBasic_NET Book

View More Programming Books

To support continued development and improvements to this book, please consider a small bitcoin donation: 1H63m55bw6KDYUaKU1mYLGrzDf4wcrVzhX