Best way to make variables in one sub available to a called sub

Jennifer Murphy · #3 02-29-2020, 12:18 AM

Quote:

Originally Posted by macropod

Any variables you declare at the top of your code module (i.e. before any subs) will be available to all subs in that code module. See, for example: https://www.msofficeforums.com/148491-post2.html

That's what I surmised.

After playing with that a bit, I decided to pass the variables I want the Sub to change with ByRef and the rest with ByVal. It's working now and I think it's more readable code. All of my declarations are together in the main Sub and it's clear what the sub Sub is working with.

Thanks.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Array to iterate through variables and trap blank variables	Marrick13	Word VBA	5	08-04-2015 06:19 AM
can word: make variables, find appropriate pages, fill out pages with variables, print only those	20GT	Word VBA	1	10-15-2014 09:48 PM
Can a function or sub be called using a variable name?	omahadivision	Excel Programming	18	12-05-2013 08:14 PM
excel where is procedure being called from	davids67	Excel Programming	1	11-18-2011 06:48 AM
What is this symbol called as?	Franky	Word	3	11-12-2011 08:16 AM