Help organizing large program

A

Andrew

Hello,
I have a VBA program, which is written all on sheet1 of a workbook. I
have about 15 subroutines and it is getting hard to navigate around
the code. I'd like to move some of the completed subs off of sheet1
and maybe put them into modules. I'd especially like to move all of
the variable declarations onto another page. I have about 100
variable, all are global with respect to sheet1. I have tried this,
but I can't get the variables to transfer over. Please advise.

1. How do I create global variables which would be visible from all
sheets and all modules?
2. How do I take a subroutine out of sheet1 and into a module?

thanks for your help
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

how to use modules so that values calculated in one of them can beused by another? 1
Keeping Variables Alive 13
use of module level variables 2
Best place to declare variables 7
Make all variable in Array = Empty each click of a Button on Userf 5
Not enough system resources to display completely 1
One Variable Available In Three Workbooks 2
Strange macro behavior - result is correct every other time 3

Top