View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Peter Rooney Peter Rooney is offline
external usenet poster
 
Posts: 325
Default Split code in more than one page ?

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