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