send sub routine variable to global

[Nigel]

so in a subroutine, i set a variable in the middle of script, and
aftewards, i wanted to use that variable globally....can i take a
variable and set a global variable with it from inside a subroutine?

 

[paul.robinson]

Hi
Declare the variable outside the sub at the top of the module, but
define it as you did inside the sub.
Then
Dim myVariable
at the top of the sub can be used inside that module.
Also
Public myVariable
at the top of the sub can be used inside the project

regards
Paul

 

[Bob Phillips]

Make it a function and return that value as the function result to the
caller.

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)