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
wrote in message
...

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