Split code in more than one page ?

I have made a pretty long page with VB code and now
I was thinking if it is possible to spilt the code over more
than just one page, and then inlcude the other pages into
the mainpage when ever they was needed ?


--
Mit fotoalbum
www.photo.activewebsite.dk

Good morning!

Yes, it is possible to have several code pages - the key thing to remember
is to declare your variables appropriately - if you declare them on one
sheet, but want them to be available to procedures in another, you'll need to
declare them with PUBLIC and not with DIM. I usually have once code sheet
just for declarations, with no code at all, just to keep things tody.

Regards

Pete

"SpookiePower" wrote:

> I have made a pretty long page with VB code and now
> I was thinking if it is possible to spilt the code over more
> than just one page, and then inlcude the other pages into
> the mainpage when ever they was needed ?
>
>
> --
> Mit fotoalbum
> www.photo.activewebsite.dk
>
>
>

"Peter Rooney" <[email protected]> skrev i en meddelelse
news:[email protected]...
> Good morning!
>
> Yes, it is possible to have several code pages - the key thing to remember
> is to declare your variables appropriately - if you declare them on one
> sheet, but want them to be available to procedures in another, you'll need to
> declare them with PUBLIC and not with DIM. I usually have once code sheet
> just for declarations, with no code at all, just to keep things tody.
>
> Regards
>
> Pete

Thanks, thats just what I was looking for, but who do
I create other pages ?

In the VBA editor, click Insert-Module from the menu.
There is also a tool you can add to the toobar to do this - it's the third
one in the "Insert" category. Onse inserted, you can rename the modules by
highlighting their names in the "Properties" window.

Regards

Pete



"SpookiePower" wrote:

> "Peter Rooney" <[email protected]> skrev i en meddelelse
> news:[email protected]...
> > Good morning!
> >
> > Yes, it is possible to have several code pages - the key thing to remember
> > is to declare your variables appropriately - if you declare them on one
> > sheet, but want them to be available to procedures in another, you'll need to
> > declare them with PUBLIC and not with DIM. I usually have once code sheet
> > just for declarations, with no code at all, just to keep things tody.
> >
> > Regards
> >
> > Pete
>
> Thanks, thats just what I was looking for, but who do
> I create other pages ?
>
>
>

"Peter Rooney" <[email protected]> skrev i en meddelelse
news:[email protected]...
> In the VBA editor, click Insert-Module from the menu.
> There is also a tool you can add to the toobar to do this - it's the third
> one in the "Insert" category. Onse inserted, you can rename the modules by
> highlighting their names in the "Properties" window.
>
> Regards
>
> Pete


Thanks