Hi,
I've read lots of threads on this, but for some reason I just can't get it to work and I'm not sure what I'm doing wrong.
I have two modules, each with several subroutines in them. I can pass a variable between subs in the same module, but I can't seem to pass them between modules.
I have tried declaring them as public and as global, but neither option works.
Could anyone please help me?
Thanks
Mike
Suggest you post your code, ideally, in the form of a sample workbook.
Regards, TMS
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Create two modules, in module1 put:
in module2 put:
Please Login or Register to view this content.
run macro_1 in module2, you should get "testing" in your msgbox - is this what you mean?Please Login or Register to view this content.
I've attached a sample workbook here.
As you will see, when you run Module1, even when passing between the two subs, the variables are kept. When it switches to another module, however, the variables are lost.
Any help would be greatly appreciated!
Thanks again
Mike
Works for me, passing the variables to module 2 - tested with the following:
So, if you still have a problem, it is not that the variable values aren't reaching module 2.Please Login or Register to view this content.
let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source
If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE
Walking the tightrope between genius and eejit...
Hi Mike - your example works for me (i.e. the variables are passed from module2 to module1)
I would not use Public variable.
Module1
Module2Please Login or Register to view this content.
Please Login or Register to view this content.
Oooh, you guys are right! Sorry, I was just looking at the locals bar at the bottom and, because my variables weren't displayed there, I assumed they hadn't been passed.
Thanks!
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
Or you can use this way:
How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save
You may also want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks