Excel VBA

Excel VBA Dictionaries

February 16, 2016 0

Excel VBA Introduction Part 39 – Dictionaries DESCRIPTION The Dictionary class is similar to the Collection class in that it allows you to store a custom collection of objects. This video teaches you how to […]

Excel VBA

Excel VBA Typed Collections

February 9, 2016 1

Excel VBA Introduction Part 38 – Typed Collections DESCRIPTION One of the issues with the Collection class in VBA is that it’s untyped. This means you can add any kind of object to the collection […]

Excel VBA

Excel VBA Custom Collections

February 2, 2016 0

Excel VBA Introduction Part 37 – Custom Collections DESCRIPTION Excel VBA is full of collections and you can even create your own custom collections using the Collection object. This video teaches you how to create […]

Excel VBA

Excel VBA Using Class Modules in Other Projects

January 26, 2016 0

Excel VBA Introduction Part 36 – Using Class Modules in Other Projects DESCRIPTION One small limitation of VBA Class Modules is that, by default, you can only use them in the VBA Project in which […]

Excel VBA

Excel VBA Class Modules

January 19, 2016 0

Excel VBA Introduction Part 35 – Class Modules DESCRIPTION Class Modules in VBA allow you to define your own classes of objects. This video explains why that’s a useful and shows you how to go […]

Excel VBA

Excel VBA Type Declarations

January 12, 2016 0

Excel VBA Introduction Part 34 – Type Declarations DESCRIPTION The Type statement in VBA allows you to define your own static data structures which you can then use in your variable declarations. This video explains […]

Excel VBA

Excel VBA Creating Add Ins

January 5, 2016 0

Excel VBA Introduction Part 33 – Creating Add Ins DESCRIPTION Creating an Excel VBA Add-In is a great way to make your custom functions available to other Excel workbooks and VBA projects. This video teaches […]

Excel VBA

Excel VBA ADO (ActiveX Data Objects) SQL Statements

December 29, 2015 0

Excel VBA Introduction Part 32 – ADO (ActiveX Data Objects) SQL Statements DESCRIPTION The ADO Command object essentially allows you to write SQL statements directly into your VBA code and execute them on whichever database […]