Passing Variables between Macros

[christian2016]

Hi Guys,

Unsure if you are able to do this.

Example
1. Macro - Sub Test
2. Macro - Sub Test2

Within macro "Test " I'm calling macro "Test2" and passing a variable. The called macro "Test2" does what it needs to do and once completed I need to pass variables back to the main macro "Test" which will use these variables to complete the rest of the code in "Test".

Any help is greatly appreciated.

Thanks

 

[Joe4]

Try using Global/Public variables instead.
Then they are available to all your macros in your procedure at any time.
See: VBA Global Variables | How to Declare Global Variables in Excel VBA?

 

[mikerickson]

You could do something like this

Sub Macro1()
    Dim aVar as Variant
    Dim bVar as Variant

    aVar = 12

    Call Macro2(aVar, bVar)

    MsgBox bVar
End Sub

Sub Macro2(inputValue as Variant, byRef outputValue as Variant)
    outputValue = inputValue + 5
End Sub

or you could cast Macro2 as a function rather than a sub.

 

[christian2016]

You could do something like this

Sub Macro1()
    Dim aVar as Variant
    Dim bVar as Variant

    aVar = 12

    Call Macro2(aVar, bVar)

    MsgBox bVar
End Sub

Sub Macro2(inputValue as Variant, byRef outputValue as Variant)
    outputValue = inputValue + 5
End Sub

or you could cast Macro2 as a function rather than a sub.

Thank you. This seems to work well