Register now or log in to join your professional community.
VBA Global variables are very helpful in some cases, Here is how you can use themPublic GBL_var1 As String Public GBL_var2 As StringOption Explicit Public Sub Init_Globals()' Access global variable initialization GBL_var1 = Environ("init_from_any_environ_call_name") GBL_var2 = " " End Subing something here End Sub