Type Scope

  • Thread starter Thread starter Jim
  • Start date Start date
J

Jim

To all,

I created a Public Type in a module as follows,

Public Type AppInfo
UserAction As String
FolderSelected As String
DBFolder As String
DBFn As String
End Type

A procedure in the module shows a form and I fill appInfo
values, but when I unload the form the values are lost?

Why is that?

Jim
 
Jim,

Where are you declaring the variable of the specified Type? If
you declare the variable in the form's code, it will be lost when
the form is unloaded. If it is declared in the same procedure
that shows the form, it will remain in scope for that procedure.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
It is declared in the Module that contains a Sub that
shows the Form. That's why I'm confused.

Jim
 
Back
Top