VBA Notes for Professionals book

VBA Book preview
VBA Notes for Professionals book

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

Chapters

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

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

210 pages, published on February 2018

View More Programming Books

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