Excel® VBA Notes for Professionals book

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

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

Chapters

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

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

127 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