Class Modules

brettvba · May 6th, 2002, 08:35 PM

What are these used for and how do you run subs in class modules?

Mark O'Brien · May 6th, 2002, 08:43 PM

Class modules are used to create your own objects. They consist of methods and properties, not subroutines.

For example, the worksheet object and userforms are special kinds of class modules.

It's quite difficult to give an overview here because they are slightly tricky to get your head around. I advise having a look online for a tutorial on how to use them, or find a decent book to take you through an example.

Do you have or have inherited a class module that's giving you some hassles?

brettvba · May 6th, 2002, 08:56 PM

no I just wanted to know what they were there for as I have seen in the object browser that some of the objects avaliable are for the class module

thanks anyway..

May 6th, 2002, 08:43 PM	#2
Mark O'Brien MrExcel MVP Join Date: Feb 2002 Location: Columbus, OH, USA Posts: 3,519	Class modules are used to create your own objects. They consist of methods and properties, not subroutines. For example, the worksheet object and userforms are special kinds of class modules. It's quite difficult to give an overview here because they are slightly tricky to get your head around. I advise having a look online for a tutorial on how to use them, or find a decent book to take you through an example. Do you have or have inherited a class module that's giving you some hassles? __________________ Mark O'Brien Columbus Ohio Celtic Supporters Club

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 6th, 2002, 08:35 PM	#1
brettvba MrExcel MVP Join Date: Feb 2002 Location: Christchurch New Zealand Posts: 1,030	What are these used for and how do you run subs in class modules?

May 6th, 2002, 08:56 PM	#3
brettvba MrExcel MVP Join Date: Feb 2002 Location: Christchurch New Zealand Posts: 1,030	no I just wanted to know what they were there for as I have seen in the object browser that some of the objects avaliable are for the class module thanks anyway..