Objects tagged with vba


Posts

← Back to the Posts

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.

Screencasts

← 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.