Need my Value to Continue to Another Called Macro

[Jeckford]

Please see example below:

Please Login or Register  to view this content.

What I would like is for myvalue to continue equaling what it equaled in Macro1 into Macro2. This is just an example, in my actual sheet I will have about 20 different values that need to continue into the next macro.

Thanks,

[JieJenn]

Maybe declare myValue as a shared private variable?

Please Login or Register  to view this content.

[Jeckford]

Hi JieJenn,

This works great thanks, but I've got one more problem. This seems to only work when both macros are in the one module. Is there any way of getting the same result with macro1 being in module 1 and macro2 being in module 2? Sorry, I should have been more specific in my first post.

Thanks again.

[TMS]

Try:

Please Login or Register  to view this content.

Regards, TMS

[Jeckford]

Excellent TMS. Works perfectly.

Thanks TMS and JieJenn for your help.

[Jeckford]

Sorry, another question. Does this now mean every variable that's part of the macro has to be defined? If I'm using x as part of a loop, but do not need to have x's value continue to the next macro, I'll still need to define it? I seem to be getting a compiler error. I have not worked with defining variable that much, so it's a bit confusing, I'm use to just typing x = 1, and nothing more.

[TMS]

You're welcome. Thanks for the rep.


Defining (Dimming/Dimensioning) your variables is good practice and mandatory if you use Option Explicit.

Option Explicit helps to avoid mistakes where, say one variable is incremented and another is tested - maybe x1 and x2.

If you really don't want to Dim your variables, remove the Option Explicit ... but you would be better off getting into the habit of defining them appropriately.

Regards, TMS

[Jeckford]

Sorry, what I should be saying is. Is there a way around not declaring variables, unless the next macro requires that variable. Not sure if this will make sense. Please see my attachment.

Thanks.

[Jeckford]

Ignore post 8. Posted that when you had replied. What you have mentioned in post 7 works great. Slowly learning the variable side of things, but don't have a good understanding, so I'm leaving them out when possible for the time being, until I understand it a bit better.

Thanks again, much appreciated.