Macros & VBA

Learn how to write macros with the VBA programming language to automate common Excel tasks and complex processes.

How to Add Macro Buttons to the Ribbon

Macros & VBA

How to Add Macro Buttons to the Excel Ribbon or Quick Access Toolbar

May 19, 2020

How to Uninstall Excel Add-in Youtube Thumb 1280x720

Add-in, Macros & VBA

How to Uninstall and Remove an Excel Add-in

January 27, 2020

Vlookup Choose vs Index Match

Formulas, Macros & VBA

VLOOKUP CHOOSE vs INDEX MATCH Performance Test

September 25, 2019

Vlookup Assistant Preview Thumbnail 2 640

Formulas, Macros & VBA

VLOOKUP Assistant – Preview

August 21, 2019

Macros & VBA

How to Unhide and Rehide Multiple Sheets in Excel

July 31, 2019

Select vs Activate in VBA for Excel

Macros & VBA

Difference Between Select and Activate Methods in VBA

July 25, 2019

Text to Time Values - Solution 4 - UDFs VBA 640 Thumb

Macros & VBA

Convert Text to Time Values with UDFs in VBA

June 5, 2019

User Defined Functions UDFs in Excel with VBA 640

Macros & VBA

How to Write User Defined Functions (UDFs) in Excel with VBA

May 29, 2019

Gridlines Freeze Panes Lost in New Window Video Thumb 640

Macros & VBA, Tips, Tips & Shortcuts

Gridlines & Freeze Panes Settings Lost in New Window – How to Fix It

April 10, 2019