Macros & VBA

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

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

Convert Text to Time Values with UDFs in VBA

June 5, 2019

User Defined Functions UDFs in Excel with VBA 640

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

4 Ways to Automatically Sort Drop Down Lists Excel 640

Formulas, Macros & VBA, Power Pivot/Query/BI, Power Query, Tips, Tips & Shortcuts

How to Sort Drop Down Lists Automatically in Excel

February 6, 2019

How to Add Macro Buttons Video 640

How to Create Macro Buttons in Excel Worksheets

January 23, 2019

VBA Delete Rows Based on Condition YouTube Thumb 640

VBA Macro to Delete Rows Based on Cell Values

January 17, 2019

Copy Data to Another Workbook Using Macros Below Existing YouTube Thumb 640

How to Use VBA Macros to Copy Data to Another Workbook

January 9, 2019

Custom Keyboard Shortcuts to Select the First or Last Sheet in Excel

Macros & VBA, Tips, Tips & Shortcuts

Create Keyboard Shortcuts to Select the First or Last Sheet in Excel

October 17, 2018

Copy VBA Code to Other Workbooks Video Thumb 640

How to Copy or Import VBA Code to Another Workbook

October 11, 2018