Create Global Variables in a module

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is it possible to set variables for access to all sub routines and functions within a module?

eg. pathB = ThisWorkbook.Path is refer to this in many sub routines

Bruce
 
Bruce,

Declare the variable outside of a macro, at the start of the module. They
can then be set/read from any procedure in that module.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Defining public/global variables in more than one place 1
Global Variables 2
ThisWorkbook.Path not updating 1
Global/Public/Universal variables 8
Outlook Private Sub Application_Startup()....What if it be public 1
Call module 2
Public Variables, Class Modules and Standard Modules 2
Transfer Variable from Form to Module 2

Back
Top