Variable losing its value when calling new sub

[jim37055]

Is there any way to keep a value in a variable when I call a new sub?

I have a the same variable name in the new sub, and I want to carry over the value that I had in the first sub which is where I set the value of the variable.

I am sure there is an easy answer to this, but I am just trying to learn as I go here..... I may be in over my head....

[Tom Ogilvy]

If the variable is declared in each sub, then these are two separate
variables only visible to their respective subs.

You can declare the variable one time as public at the top of the module and
use it in both subs (remove any other declarations)

Public MyVar as Variant

Sub Init_Myvar()
MyVar = int(rnd()*1000+1)
ShowMyVar
End Sub

sub ShowMyVar()
msgbox MyVar
End Sub

---------------------
or you can past the variable in between
--------------------
Sub Init_Myvar()
Dim MyVar as Variant
MyVar = int(rnd()*1000+1)
ShowMyVar MyVar
End Sub

Sub ShowMyVar(someVar as Variant)
msgbox someVar
End Sub

somVar is a place holder for the variable MyVar


--
Regards,
Tom Ogilvy

"jim37055" <jim37055
[email protected]> wrote in message
news:[email protected]...
>
> Is there any way to keep a value in a variable when I call a new sub?
>
> I have a the same variable name in the new sub, and I want to carry
> over the value that I had in the first sub which is where I set the
> value of the variable.
>
> I am sure there is an easy answer to this, but I am just trying to
> learn as I go here..... I may be in over my head....
>
>
> --
> jim37055
> ------------------------------------------------------------------------
> jim37055's Profile:
http://www.excelforum.com/member.php...o&userid=27788
> View this thread: http://www.excelforum.com/showthread...hreadid=473844
>

[Jim Thomlinson]

You can pass variables as arguments...

Sub Test()
dim i as integer

i = 100
call DisplayI(i)
i = i + 50
call DisplayI(i)
end sub

sub DisplayI(byval i as Integer)
msgbox "The value of i is " & i
end sub
--
HTH...

Jim Thomlinson


"jim37055" wrote:

>
> Is there any way to keep a value in a variable when I call a new sub?
>
> I have a the same variable name in the new sub, and I want to carry
> over the value that I had in the first sub which is where I set the
> value of the variable.
>
> I am sure there is an easy answer to this, but I am just trying to
> learn as I go here..... I may be in over my head....
>
>
> --
> jim37055
> ------------------------------------------------------------------------
> jim37055's Profile: http://www.excelforum.com/member.php...o&userid=27788
> View this thread: http://www.excelforum.com/showthread...hreadid=473844
>
>