Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help organizing large program
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help organizing large program
Use a Public Sub! Look at this:
http://www.your-save-time-and-improv...ivate-sub.html HTH, Ryan--- -- Ryan--- If this information was helpful, please indicate this by clicking ''Yes''. "Andrew" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using the functions "LARGE"and "SMALL" in an Excel program | Excel Programming | |||
Organizing the VBE | Excel Programming | |||
Program too large | Excel Programming | |||
looping through and organizing a large amount of data | Excel Programming | |||
organizing a large amount of data into a table | Excel Programming |