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

		Microsoft Office Forums > Microsoft Word > Word VBA
Best way to make variables in one sub available to a called sub

FAQ

Thread Tools

Display Modes

02-28-2020, 11:44 PM

macropod

Windows 7 64bit Best way to make variables in one sub available to a called sub

Office 2010 32bit

Administrator

Join Date: Dec 2010

Location: Canberra, Australia

Posts: 22,467

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

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

« Previous Thread | Next Thread »

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

Other Forums: Access Forums

All times are GMT -7. The time now is 01:11 AM.