Excel® VBA Notes for Professionals book

Excel® VBA Book preview
Excel® VBA Notes for Professionals book

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

Chapters

  1. Getting started with Excel VBA
  2. Arrays
  3. Conditional statements
  4. Ranges and Cells
  5. Named Ranges
  6. Merged Cells / Ranges
  7. Locating duplicate values in a range
  8. User Defined Functions (UDFs)
  9. Conditional formatting using VBA
  10. Workbooks
  11. Working with Excel Tables in VBA
  12. Loop through all Sheets in Active Workbook
  13. Use Worksheet object and not Sheet object
  14. Methods for Finding the Last Used Row or Column in a Worksheet
  15. Creating a drop-down menu in the Active Worksheet with a Combo Box
  16. File System Object
  17. Pivot Tables
  18. Binding
  19. autofilter ; Uses and best practices
  20. Application object
  21. Charts and Charting
  22. CustomDocumentProperties in practice
  23. PowerPoint Integration Through VBA
  24. How to record a Macro
  25. SQL in Excel VBA - Best Practices
  26. Excel-VBA Optimization
  27. VBA Security
  28. Debugging and Troubleshooting
  29. VBA Best Practices
  30. Excel VBA Tips and Tricks
  31. Common Mistakes

Example book pages

Excel® VBA Example Page 1Excel® VBA Example Page 2
Excel® VBA Example Page 3Excel® VBA Example Page 4

What people are saying about Notes for Professionals books

The Excel® 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 Excel® VBA group(s), company(s) nor Stack Overflow. All trademarks belong to their respective company owners

128 pages, published on June 2018

Sign up for changes to Excel® VBA Notes for Professionals book

DotNETFramework Book
CSharp Book
HTML5 Book
EntityFramework Book
MicrosoftSQLServer Book
PowerShell Book
R Book
VBA Book
VisualBasic_NET Book

View More Programming Books

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