what can classmodules do

[sybmathics]

Hi,

I am programming slotmachine-algorythms in excel to find a way to become
rich without working.

I know how to create a user interface, to create modules and connecting
subroutines, to create functions. However, I keep stumbling on the fact that
when I have created a subroutine for one programme and want to use this for
a next programme, I need to copy and paste the routine.

Is there a way out of this?

When I look at the helpdescription of classmodules I figure this could be of
some help, but when I'm in such a classmodule I don't know what to do.


Any help is greatly appreciated,

greets,

Sybolt

 

[TomHinkle]

you'll still have to copy a class module from one project to another..
Stick to modules.

A class module pretty much codes the same as a regular module, but using it
is WAY different.

you use a class to define something you're going to make more and more of.

For an example (programmers, realize I'm simplifying the description here).

A worksheet is an example of a class.

you can write

dim X as worksheet

set X = new worksheet

then use X as if it were a variable.

In your program try this in a class module


Name it myclass

put this code in it

public X as long
public Y as long




then in a code module write this

dim FirstTest as myclass
dim SecondTest as myclass

set firstTest = new myclass
set secondTest = new myclass

firstTest.x = 5
SecondTest.x = 10

debug.print "first " & firstTest.x
debug.print "second " & secondtest.x

 

[Chip Pearson]

A class module won't necessarily help, and doesn't seem terribly
well suited to your application. Instead, put all your common
procedures in a workbook. Then, in the VBA Editor, go to the
Tools menu, choose VBA Project Properties, and change the name of
the project to something meaningful. Finally, in the workbooks
that need to use the procedures, in VBA go to the Tools menu,
choose References, and check the reference to the project
containing your common routines.


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

 

[Bob Phillips]

A worksheet is an example of a class.

you can write

dim X as worksheet

set X = new worksheet

Just give that a try, and see if you can!

 

[Jim Thomlinson]

I am not convinced that a class module is what you need here. They are handy
in some situations such as events but judging by your question that is not
the case here. For many of my common utility type functions and procedures I
create modules and give them meaningful names. A module can be exported
(right click the module and you will see export as an option). For your next
project that needs that functionallity just right click the project and
select import. I have modules for creating toolbars, error handling, string
manipulations, ADO Connections, Network Connections... any of which I can
just plug into a new project to get the functionality I want. Similar(ish) to
C programming where you add a header file.

 

[TomHinkle]

Read the whole thread...

"For an example (programmers, realize I'm simplifying the description here)."

I used worksheet because I figured it would be something someone could
relate to..

If you read the WHOLE post you'd realize I was trying to describe a class in
a short amount of space.

Sorry if you don't get it.

 

[Bob Phillips]

Read the whole thread...

"For an example (programmers, realize I'm simplifying the description

here)."

Simplifying and giving wrong information are poles apart.

I used worksheet because I figured it would be something someone could
relate to..

But what you are saying is wrong,. So that invalidates everything you said.

If you read the WHOLE post you'd realize I was trying to describe a class in
a short amount of space.

If you can't explain correctly, it is best not to give erroneous
information.

Sorry if you don't get it.

Who doesn't get it?

 

[TomHinkle]

Instead of trying to be cute, why don't you just expand on answers that you
feel are incomplete with your knowledge.. maybe some of us could learn
something..

 

[Bob Phillips]

I don't think it is necessary to use class modules in this case as others
have said. Explaining class modules is difficult (as Jamie Collins says,
class modules is something that you don't get until you get it). I know how
hard it is and am compiling a paper on the subject at the moment, so I
certainly wouldn't try to explain it in a NG response, especially when the
OP doesn't need it.

But giving wrong information should be challenged, it isn't being cute, it
is trying to stop misleading information.

Bob

 

[Mike NG]

However, I keep stumbling on the fact that
when I have created a subroutine for one programme and want to use this for
a next programme, I need to copy and paste the routine.

I just save my module as an XLA file for my common routines

 

[Jim Thomlinson]

That works great so long as you don't have to distribute the spreadsheet.
Otherwise you have to give the xla along with the spreadsheet... That being
said everyone in my department has one of my xla's installed and so it works
great.

 

[keepITcool]

or until you get it instantiated

--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam


Bob Phillips wrote :

 

[Jim Thomlinson]

Can I get a copy of the paper when you are done? I "get it" and I would still
love to get a copy.

P.S. Tom if you find a response to a solution you post to be impolite or
disrespectful, I can assure you that it is never meant that way. Bob is one
of the best coders on the forum and I am sure no disrepect was intended. He
called you on a mistake which we all have made. When a mistake is posted I
can assure you the error will be pointed out.

 

[Bob Phillips]

Can I get a copy of the paper when you are done? I "get it" and I would still
love to get a copy.

Of course Jim, when it is ready it will be posted in the public domain
anyway. If you are that keen, perhaps you would be willing to do a peer
review on it for me. Perhaps we can have an offline email exchange on it.

Regards

Bob