1)difference between class module and and standard module??

please provide one example for class module ...

Hi rami y,

Based on your description, I suppose you can refer to this article about difference between Class Modules and Standard Modules and this link provides several samples about your question:

https://msdn.microsoft.com/en-us/library/aa240811(v=vs.60).aspx

If my understanding is incorrect, I suggest you provide more information about your question.

I'm glad to help and follow up your reply.

Regards,

Emi Zhang
TechNet Community Su