Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
calling a routine to declare variables at start of macro
Hello all,
I have about 40 variables that I currently declare before running about 5 macros. All of these are the same across the macros because they set things like column numbers and start and end rows for the spreadsheets I work with. The macros all reside in the same sheet. How can I make it so that the variables all sit in one spot and are referenced by the 5 different macros? Can I write a function that declares the variables and then call that function in each of my 5 macros? I tried doing that but the macro did not recognize the variables even after making them Public. Thanks! Here is some sample code showing the variables I want to share across the macros: SP_Index = 3 SP_CA = 4 SP_WP = 5 etc... |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
calling a routine to declare variables at start of macro
I'd create a new module that has this in it:
Option Explicit Public VarsAreInitialized as Boolean Public SP_Index as long 'or double or whatever Public SP_CA as long .... Sub InitializeVariables() VarsAreInitialized = true sp_index = 3 sp_ca = 4 ... End sub Then in each of the routines that depend on those variables: Option Explicit Sub FirstSub() if varsareinitilized then 'do nothing else call initializeVariables end if ...rest of code End sub Michael wrote: Hello all, I have about 40 variables that I currently declare before running about 5 macros. All of these are the same across the macros because they set things like column numbers and start and end rows for the spreadsheets I work with. The macros all reside in the same sheet. How can I make it so that the variables all sit in one spot and are referenced by the 5 different macros? Can I write a function that declares the variables and then call that function in each of my 5 macros? I tried doing that but the macro did not recognize the variables even after making them Public. Thanks! Here is some sample code showing the variables I want to share across the macros: SP_Index = 3 SP_CA = 4 SP_WP = 5 etc... -- Dave Peterson |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
calling a routine to declare variables at start of macro
On Aug 12, 1:52*pm, Dave Peterson wrote:
I'd create a new module that has this in it: Option Explicit Public VarsAreInitialized as Boolean Public SP_Index as long 'or double or whatever Public SP_CA as long ... Sub InitializeVariables() * VarsAreInitialized = true * sp_index = 3 * sp_ca = 4 * ... End sub Then in each of the routines that depend on those variables: Option Explicit Sub FirstSub() * *if varsareinitilized then * * * 'do nothing * *else * * * call initializeVariables * *end if * *...rest of code End sub Michael wrote: Hello all, I have about 40 variables that I currently declare before running about 5 macros. *All of these are the same across the macros because they set things like column numbers and start and end rows for the spreadsheets I work with. *The macros all reside in the same sheet. How can I make it so that the variables all sit in one spot and are referenced by the 5 different macros? *Can I write a function that declares the variables and then call that function in each of my 5 macros? *I tried doing that but the macro did not recognize the variables even after making them Public. *Thanks! Here is some sample code showing the variables I want to share across the macros: * * SP_Index = 3 * * SP_CA = 4 * * SP_WP = 5 etc... -- Dave Peterson- Hide quoted text - - Show quoted text - that worked great! thanks a bunch!!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Declare Variables in Array | Excel Discussion (Misc queries) | |||
Declare and Set Public variables | Excel Discussion (Misc queries) | |||
DECLARE VARIABLES PROBLEM | Excel Programming | |||
declare multiple variables | Excel Programming | |||
Calling Macro - Will it take variables? | Excel Programming |