Free Excel VBA Book

What is Excel VBA ?

Visual Basic for Applications is an implementation of Microsoft’s event-driven programming language Visual Basic 6, which was discontinued in 2008, and its associated integrated development environment.

Chapters

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

Get your book just click on download button