Declaring Public variables and accessing in other modules

Charles Kenyon · #9 11-22-2020, 11:13 PM

Code:

Option Explicit
Public projectPath As String

Static Sub setFilePath()
    Let projectPath = "This is my filepath"
End Sub

Sub ShowprojectPath()
    MsgBox "projectPath = " & projectPath
End Sub

The value of projectPath will disappear when the template/document with the code is closed. It should be available to any other procedure/function in the module. Perhaps it will be available to any other procedure/function in the project; I am uncertain and have not tested.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Combining 3 Modules into 1	Jude24Joy	Word VBA	5	02-01-2017 04:20 PM
Declaring a variable that is known across modules	Officer_Bierschnitt	Excel Programming	5	11-18-2015 12:28 PM
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
Empty Modules	Greg S.	Excel Programming	2	07-30-2013 01:38 PM