Amnesia of global object variables

[nigelandrewfoster]

Is there any way of declaring and setting the value of a global object variable so it keeps its value when the procedure ends? The system I'm developing runs separate macros according to the user's clicking on clip art, returning the user to Excel level after each one has run. As it stands, the moment the macro finishes, all the global object variables I have declared are cleared, so the next click generates an "Object variable or With block not set" error. I have gotten around this by writing a macro which simply contains SET statements for them all, and each macro then starts with a CALL command to this macro. Is that the correct way to go, or is there a more direct way, please? As ever, I appreciate your time!
Nigel

 

[nigelandrewfoster]

I was doing it to enable to macros to run without them stopping with Object variable etc not set error. Now inclined to think I'm causing this problem as I'm testing them. I'm in new territory here: A user could potentially run one of five macros at this point, each one shares information with the others, so relying heavily on global variables.

 

[RoryA]

As a general rule, you should try and pass variables directly between procedures rather than relying on globals, though there are times when you have to use them.

 

[nigelandrewfoster]

Thanks. What do you mean by "pass directly between procedures", exactly, please?

 

[RoryA]

Rather than:

Public rng as range
Sub Macro1()
set rng = Range("A1")
call macro2
End Sub
Sub Macro2()
rng.value = "Hello"
End Sub

you do:

Sub Macro1()
Dim rng as Range
set rng = Range("A1")
call macro2(rng)
End Sub
Sub Macro2(rng as Range)
rng.value = "Hello"
End Sub

 

[nigelandrewfoster]

Thanks for that. Simple, no doubt, but I am very slow picking up VBA concepts, since I still think too much in terms of BASIC. Appreciated.