Excel® VBA Notes for Professionals book

Excel® VBA Notes for Professionals book
  • 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

Download PDF Book

Example book pages

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

645 Views

Leave a Reply

Your email address will not be published. Required fields are marked *