A long time back, I dreamt of having a highly popular blog relating to #VBA (Visual Basic for Applications) and how it can be leveraged in #MSExcel to create new #Objects, by writing code for the #ClassModules in such a way that the same code could be used over and over to handle an extremely repetitive task, say for example:
(1) The creating of an Employee in the organization. The beauty of this approach was that I could just declare “Set objEmp = New clsEmployee” in my code, and BOOM, that was that!! Or
(2) Creating a new Cash Payment Voucher, where the similar code would be “Set objCPV -= New clsCPV”.
Obviously the class module in either case would differ, in the sense that there would be different Subs and Functions, along with the necessary Events defined within the Class Module. Since this approach would be compliant with the #ObjectOrientedProgramming methodology, it slowly and steadily became my #GoTo attitude while doing any kind of #VBACoding in #ExcelVBAAhmFCA style of coding. Cheers!!
CA Vikram Shankar Mathur
vbacoder.1962@gmail.com
May 17th, 2025 @ 01:20 Hours IST
Leave a comment