Visual Basic global variables in Excel Macro

Question

I writing macro for excel on VB. There is a structure:

Forms Form1 Modules Main

In the Form1 I have Button click event

Public Sub CommandButton1_Click() MsgBox GLOBALVAR 'I need access to GLOBALVAR here End Sub

In the Main I have procedure Test

Sub Test GLOBALVAR = "VALUE" End Sub

How I can implement it? I can't create

Module GlobalVariables End Module

Due to Excel does not support this construction!

user2140173 · Accepted Answer · 2014-08-05 14:47:52Z

1

Add a

Public MyGlobalVariable as String

in the Module1

enter image description here

and it becomes accessible in your userform

enter image description here

answered Aug 5, 2014 at 14:47

user2140173

Sign up to request clarification or add additional context in comments.

1 Answer 1