If you have seen a lot of VBA code, not once were you probably horrified to see a junkyard of random Subs and Functions with no obvious relationship between them. Personally I am a fan of (VBA) Classes as they require abstract thinking and a modular approach to writing code (in this case VBA).
But what is a Class? A Class allows you to encapsulate any level of abstraction and complexity into a single object and facilitate only an interface (certain procedures or methods if you prefer) to this object.īest book to learn OOP concepts (link to Amazon) Why use Classes? Although we can argue how much is VBA actually an Object Oriented Programming language, there is no doubt that VBA allows you to create Classes similarly as in Java or C#. Classes in at the core of all Object Oriented Programming languages. The VBA Class allows you to define your own objects with unique properties and methods in VBA.
0 kommentar(er)
