Class module

[David]

hi guys,
Using "Excel 2002 VBA" book. This is the first instance
of creating a Class Module and I don't see how it is
created as a Class Module. After typing the code, I do
know how to save it as a "Class Module". Must be missing
something very basic here. Code is simple:

Option Explicit
Public Name As String
Public HoursPerWeek As Double
Public rate As Double

Public Function WeeklyPay() As Double
WeeklyPay = HoursPerWeek * rate
End Function

I have done some before, but have not created "Class
Modules"

Thanks

 

[Chip Pearson]

David,

In the VBA Editor, go to the Insert menu and choose Class Module.
Put your code there. Then, press F4 to display the properties
window and name the class module what you want the class to be
called.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

 

[Tom Ogilvy]

Did you do Insert => Class Module and put your code there?

 

[David]

Thanks. This worked, but I am still trying to understand
the "Class Module", so I am looking for some kind of a
definition on what is is I am doing. I am not new to
programming, but this is the first "Class module" I have
created. It appears I am creating am creating an object,
bt I am wondering if there is a definiation of what a
class module is is it's essence. I looked through the
knowledge base, but some how am missing the "essence" of
what a class is.

Thank you for your help. The book I am using is not very
explicate. The first example in it does not even work,
but comes up with an error?

 

[Tom Ogilvy]

Try going to Chip Site

http://www.cpearson.com/excel.htm

then go to the topics or pages index and see if you can capture the essence.

Search the news groups for posts by Chip - he has given some long
explanations of such concepts. Here are the results of a search I did:

http://tinyurl.com/yw2ev

for example, the first entry from above might be helpful. (includes
additional information from Stephen Bullen).