Free Excel VBA Book

Order a coffee!

Excel® VBA Notes for Professionals book

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

Chapters

Getting started with Excel VBA
Arrays
Conditional statements
Ranges and Cells
Named Ranges
Merged Cells / Ranges
Locating duplicate values in a range
User Defined Functions (UDFs)
Conditional formatting using VBA
Workbooks
Working with Excel Tables in VBA
Loop through all Sheets in Active Workbook
Use Worksheet object and not Sheet object
Methods for Finding the Last Used Row or Column in a Worksheet
Creating a drop-down menu in the Active Worksheet with a Combo Box
File System Object
Pivot Tables
Binding
autofilter ; Uses and best practices
Application object
Charts and Charting
CustomDocumentProperties in practice
PowerPoint Integration Through VBA
How to record a Macro
SQL in Excel VBA - Best Practices
Excel-VBA Optimization
VBA Security
Debugging and Troubleshooting
VBA Best Practices
Excel VBA Tips and Tricks
Common Mistakes

Example book pages

What people are saying about Notes for Professionals books

Great resources, free books with lot of notes about some #programming technologies and languages

This is really cool! Thanks a lot!

Wow. This is awesome. Thank you!

Good stuff thanks

Really nice and condensed collection, thanks to all co-authors

Wow! Awesome resource. Thanks a lot!

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 2019