Variable Scope

[Kevin]

How do I set variables that will remain in scope as long
as my application is open. I need to set several variables
that I need to access (and possibly modify) at any time
after it is initially set while my application is open.

Help here would be greatly appreciated!

Thanks!

Kevin

 

[Tom Ogilvy]

At the top of a standard module outside any procedure

Public Myvar as Variant
Public MyString as String

for example.

then in the workbook_open event in the ThisWorkbook Module

Private Sub workbook_Open()
Myvar = 21
MyString = "Today is " & format(date,"mm/dd/yyyy")

End Sub