VBA Tutorial CodePersonal Macro Workbook
Friday, December 3, 2021
How to add it to your Quick Access Toolbar (QAT):
VBA Take a Screenshot of a PDF and Paste into Workbook
Sunday, November 21, 2021
Video: Tools — References in VBE: Code:
Open Wildcard File in Internet Explorer from Folders and Close IE VBA
Sunday, November 21, 2021
Video: Code:
Save Selected Emails with Custom Name VBA Outlook – Avoid Too Long Email Names
Sunday, November 14, 2021
The below code lets you select the name for an email before saving it. Make sure that you have the below enabled in Tools — References in your…
Create VBA shortcuts to Folder Paths
Sunday, November 14, 2021
In the above video, I show you how to add a RowSource in the View > Properties Window in the Visual Basic Editor. This rowsource value, similar to…
Quick Documentation
Wednesday, October 20, 2021
This article contains a quick way to document stuff. I don't feel like explaining it today. The first CommanButton1_Click executes the ok subprocedure in the Module 1. I…
Fill Userform with Values VBA
Saturday, April 10, 2021
The program below shows you how to add values to a listbox in a userform with Excel VBA. Code: Userform lesson: You can watch my advanced mouse control…
Excel Cell and Font Color VBA
Saturday, April 10, 2021
The below workbook and code shows you the color index for Excel fonts and cell colors. It also shows you how to do an IF statement based on…
Count Folders and Rename Folders VBA Excel
Thursday, April 8, 2021
The code and workbook below counts the number of folders in a folder. It then renames the folders in that folder incrementally based on the values in cells…
Save All Outlook Attachments Selected Emails
Wednesday, April 7, 2021
This article shows you how to automatically save all attachments for the selected emails in Outlook with VBA into the designated folder. Code: Here's an alternative version (above…
Excel VBA Filter
