by Paul Kelly | | VBA Language
“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...
by Paul Kelly | Jun 29, 2016 | Classes and Objects
“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...