Microsoft Office Forums - View Single Post - [Solved] Best way to make variables in one sub available to a called sub

Thread: [Solved] Best way to make variables in one sub available to a called sub

View Single Post

Old

02-28-2020, 11:44 PM

macropod

macropod is offline

macropod uses Windows 7 64bit

Windows 7 64bit macropod uses Office 2010 32bit

macropod uses Office 2010 32bit

Office 2010 32bit

Administrator

Join Date: Dec 2010

Location: Canberra, Australia

Posts: 22,467

macropod has a reputation beyond repute

macropod has a reputation beyond repute

macropod has a reputation beyond repute

macropod has a reputation beyond repute

macropod has a reputation beyond repute

macropod has a reputation beyond repute

macropod has a reputation beyond repute

macropod has a reputation beyond repute

macropod has a reputation beyond repute

macropod has a reputation beyond repute

macropod has a reputation beyond repute

Default

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]

Reply With Quote