Using a variable from one macro in another macro

[JimM]

Hi guys

Is it possible to use a variable derived from one macro in another macro ?

eg If in macro1 below I put in 5 when asked, could I then get it to automatically run macro2 and give the answer of 6

Thanks

Jim

sub Macro1
myvar = inputbox ("enter a number bewteen 1 and 10")
end sub

sub macro2
myanswer = myvar +1
msgbox myanswer
end sub

 

[VoG]

One way

Sub Macro1()
myvar = InputBox("enter a number bewteen 1 and 10")
Call macro2(myvar)
End Sub

Sub macro2(myvar)
myanswer = myvar + 1
MsgBox myanswer
End Sub