Objects tagged with vba


← Back to the Posts

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.