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.
--
HTH...

Jim Thomlinson


"sybmathics" wrote:

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