Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Class module
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Class module
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 "David" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Class module
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? -----Original Message----- 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 "David" wrote in message ... 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 . |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Class module
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). -- Regards, Tom Ogilvy "David" wrote in message ... 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? -----Original Message----- 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 "David" wrote in message ... 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 . |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Class module
Did you do Insert = Class Module and put your code there?
-- Regards, Tom Ogilvy "David" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Creating UDF by Class Module (Leo)? | Excel Discussion (Misc queries) | |||
CLASS MODULE & SIMPLE MODULE | Excel Discussion (Misc queries) | |||
Variable from a sheet module in a class module in XL XP | Excel Programming | |||
please give an example of a class module. | Excel Programming | |||
how to declare a class module | Excel Programming |