MattSmithProg
Programmer
Hi,
I have been programming in VBA for over 2 years now and have never found the need to use class modules. For all the reading I do everyone is recomending using them. I can see the benefits of using them but what I would use them for I can put in normal modules.
The major reason that I would use them for is common code that I use in many of my apps. If the code could be referenced in one place such that I only have to make any modifications in one place and all references to the class modules reflect the changes would be ideal. However, I am stumped as to how to do this. I thought adding a reference to the workbook that contains the class module would be the solution. However, it doesn't seem to work.
Does anyone have any ideas.
Thanks Matt Smith
No two nulls are the same
I have been programming in VBA for over 2 years now and have never found the need to use class modules. For all the reading I do everyone is recomending using them. I can see the benefits of using them but what I would use them for I can put in normal modules.
The major reason that I would use them for is common code that I use in many of my apps. If the code could be referenced in one place such that I only have to make any modifications in one place and all references to the class modules reflect the changes would be ideal. However, I am stumped as to how to do this. I thought adding a reference to the workbook that contains the class module would be the solution. However, it doesn't seem to work.
Does anyone have any ideas.
Thanks Matt Smith
No two nulls are the same