Send Emails from Excel with VBA and Outlook (With Attachments)
A tested Excel VBA macro that sends personalised Outlook emails from a list — with attachments, CC, a preview mode and a log column.
Read article →Excel VBA
Step-by-step VBA lessons and ready-to-use macros.
Link Excel Charts to PowerPoint and Refresh Them Automatically
Link Excel Charts to PowerPoint and Refresh Them Automatically
Paste Excel charts into PowerPoint as linked objects so monthly decks update with one click — plus a VBA macro that refreshes every link…
Read article →VBA Dictionary: Fast Lookups and Unique Lists in Your Macros
VBA Dictionary: Fast Lookups and Unique Lists in Your Macros
Use the Scripting.Dictionary in Excel VBA: create one, add and update keys, count and total by key, get unique lists, compare text case-insensitively, early…
Read article →Build a Data Entry Form in Excel VBA (UserForm Step by Step)
Build a Data Entry Form in Excel VBA (UserForm Step by Step)
Create a VBA UserForm for clean data entry: design the form, fill drop-downs from a table, validate inputs, add rows to an Excel Table,…
Read article →