• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Difference between module and class module

V

VDS

Member
@Dear All,

Is anybody can tell me difference between module and class module. The reason being when we press ALT+F11, displays a window. and any VB Code/macro to be inserted in module to get desired program executed.

Does the same code work in class module also ?

VDS
 
Hi ,

The difference is enormous ; the two are totally different , and the expertise required to code using class modules is much more than that required to code standard modules.

You need to read a lot to really come to grips with classes ; see these links :

1. http://www.thelandbeyondspreadsheet...ss-modules-for-something-useful-in-excel-vba/

2. http://www.cpearson.com/excel/classes.aspx

3. http://www.excelforum.com/excel-programming-vba-macros/501243-module-vs-class-module.html

4. http://msdn.microsoft.com/en-us/library/aa733572(v=vs.60).aspx

5. http://msdn.microsoft.com/en-us/library/7825002w(v=vs.90).aspx

6. http://msdn.microsoft.com/en-us/library/ca22fyhc(v=vs.90).aspx

Narayan
 
Narayan Sir,

Thank you. I will go through it and get enough knowledge.
One more thing, how can I insert a hyperlink when referring to another post just like you have done here.


VDS
 
Hi ,

I think using the full address , inclusive of the http:// , makes the forum software recognize it as a hyperlink ; have you tried it and has it not worked ?

Narayan
 
Narayan Sir,

I never tried before. This time only I came to know about this. Surely check it out and revert.


VDS
 
You must log in or register to reply here.
Back
Top