Basics of VBA / Macros Chapter – 3 (Declaring Variables Part-1)
Here we learn how to declare, initialize and display a variable in Excel VBA. To tell that we are using a variable is called…
Read article →Excel VBA
Step-by-step VBA lessons and ready-to-use macros.
Basics of VBA / Macros Chapter – 2 (Creating Macro)
Basics of VBA / Macros Chapter – 2 (Creating Macro)
With VBA you can automate tasks in Excel by writing so called macros. We will learn how to create a simple macro which will be…
Read article →Basics and Abbreviations of VBA / Macros Chapter – 1
Basics and Abbreviations of VBA / Macros Chapter – 1
VBA full form is Visual Basic for Applications. It is the programming language of Excel and other Office programs. Points to be learned for…
Read article →VBA Plus / Macros Chapter – 1 (Swap Values – 1)
VBA Plus / Macros Chapter – 1 (Swap Values – 1)
This example teaches you how to swap two values in Excel VBA. You will often need this structure in more complicated programs
Read article →VBA Project: Generate PDF Invoices From Excel and Email Them Automatically
VBA Project: Generate PDF Invoices From Excel and Email Them Automatically
A complete VBA project: fill an invoice template from a data sheet, export each invoice to PDF with a proper file name, and email…
Read article →Run-time Error 1004 in Excel VBA: 7 Common Causes and How to Fix Them
Run-time Error 1004 in Excel VBA: 7 Common Causes and How to Fix Them
Run-time error 1004 is Excel VBA’s catch-all error. Here are the 7 causes I see most often — with the exact fix for each.
Read article →5 Ways to Find the Last Row in Excel VBA (and When Each One Fails)
5 Ways to Find the Last Row in Excel VBA (and When Each One Fails)
Five ways to find the last used row in Excel VBA — End(xlUp), UsedRange, Find, CurrentRegion and ListObject — with the traps each one…
Read article →Automate SAP from Excel: Run a Report and Export It with SAP GUI Scripting
Automate SAP from Excel: Run a Report and Export It with SAP GUI Scripting
Step-by-step: enable SAP GUI Scripting, record a transaction, and run it from Excel VBA to export a report automatically.
Read article →VBA: Loop Through Every File in a Folder (and Combine Them)
VBA: Loop Through Every File in a Folder (and Combine Them)
Process every file in a folder with VBA: Dir loops, picking a folder with FileDialog, opening workbooks quietly, copying data into a master sheet…
Read article →VBA Collections and Dictionaries: Unique Lists, Counts and Fast Lookups
VBA Collections and Dictionaries: Unique Lists, Counts and Fast Lookups
Excel VBA course lesson 14: when to use a Collection or a Scripting.Dictionary, build unique lists, count and total by key, look up values…
Read article →VBA UserForms for Beginners: Build a Data-Entry Form Step by Step
VBA UserForms for Beginners: Build a Data-Entry Form Step by Step
Excel VBA course lesson 13: design a UserForm, fill combo boxes from a sheet, validate inputs, write a new row to a table, and…
Read article →VBA Events: Macros That Run by Themselves (Worksheet_Change and More)
VBA Events: Macros That Run by Themselves (Worksheet_Change and More)
Excel VBA course lesson 12: Workbook_Open, Worksheet_Change, SelectionChange and BeforeSave events — timestamps when a cell is edited, auto-uppercase codes, validation, and how to…
Read article →