Conclusion
Whenever we create a class module in VBA, the compiler creates both the class and a default interface for it. The code in the class defines how the object behaves, and the interface defines how we access the code. With a small amount of effort, we can define our own custom interfaces and implement them in our classes, enabling us to treat different classes as if they were the same type of object.When developing userforms, we can use a custom interface to expose only the properties and methods that apply to the functionality we're providing, without cluttering the IntelliSense list with all the basic userform's properties. By doing this, we can make our code more generic, more robust, more reliable, easier to write and easier to maintain.By implementing a standard custom interface in all our forms, reports and processes, we can design an application architecture that is totally extensible, without requiring any changes to the core application. If working in a multideveloper team, this interface can be extended across workbooks, allowing each developer to work independently on the application's functions, safe in the knowledge that his work will not directly impede any of the other developers. |
لطفا منتظر باشید ...
