VBA Dim – A Complete Guide

VBA Dim – A Complete Guide

“One man’s constant is another man’s variable.” – Alan Perlis   This post provides a complete guide to using the VBA Dim statement. The first section provides a quick guide to using the Dim statement including examples and the format of the Dim...
VBA Objects – The Ultimate Guide

VBA Objects – The Ultimate Guide

“High aims form high characters, and great objects bring out great minds” – Tryon Edwards   A Quick Guide to VBA Objects TaskExamples Declare and CreateDim coll As New Collection Dim o As New Class1 Declare OnlyDim coll As Collection Dim o As Class1 Create...