Objects tagged with vba


← Back to the Posts

An Elegant Way to Clear the Excel VBA Immediate Window When Debugging

Published on October 17, 2018 at 04:45AM

Your Immediate Window is so jammed with debug.print that you just want to clean slate it... quickly... and elegantly... like a gazelle.

5 Level Cascading Validation Lists in Excel using VBA

Published on October 11, 2018 at 12:18PM

You need validation lists to change based on selections... like a cascading validation list

Building Your Own (And Better) Autosave Feature for Excel

Published on June 07, 2018 at 11:13PM

Because the current Excel Autosave is just so bad XD

Automate Excel Table Filters Using VBA and Activate them Using Hyperlinks

Published on February 07, 2018 at 06:07AM

Now you can click a metric in one of your Worksheet reports and be taken straight to the underlying data in a way that is easy to see.

Add Hyperlinks to an Entire Column using VBA in Excel

Published on February 05, 2018 at 04:50AM

Convert Salesforce id and name to clickable hyperlinks in an Excel table after extracting data from Power Query

[SOLVED] Excel VBA Get Financial Year from Date - No Formula

Published on January 23, 2018 at 01:42AM

Convert a date to the Financial Year (Fiscal Year) like '01/01/2017' = '2018'. Australian example used. Pure VBA without Excel formulas. Just the solution.

IFNIL formula in Excel

Published on August 30, 2017 at 07:00AM

Often you don't want to wrap an IF statement when you just want to turn a 0 result into another value such as blank

Macro to Backup Excel VBA Code within an Excel Workbook

Published on August 24, 2017 at 06:20AM

Backup all the VBA codes to Git

Quickly Switch Between Worksheets in Excel using Shortcut (Alt+Backtick)

Published on June 19, 2017 at 01:31AM

Copy this to your PERSONAL.XLSB to quickly switch between Worksheets on the ActiveWorkbook

VBA for Last Saved At Timestamp with Hours Minutes and Seconds Ago

Published on May 04, 2017 at 06:50AM

Useful to have as a button or invoke overtime to alert when you have forgotten to save

Boilerplate Excel VBA Functions module

Published on February 15, 2017 at 05:59AM

A basic module I load to each project for shared functionality

Get Row Number in Worksheet in Excel Using VBA

Published on February 13, 2017 at 10:54AM

A simple function to return the row number of a table where a value is matched in a column. Like a VLOOKUP or INDEX MATCH for VBA.


← Back to the Screenasts

Introduction to Visual Basic for Applications VBA

Published on May 18, 2017 at 05:32AM

A short introduction to VBA by building something simple

Introduction to the Visual Basic Editor VBE

Published on May 13, 2017 at 01:55PM

Go under the Excel hood by getting to know the Visual Basic Editor. The power house of the Excel workbook.