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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Strange error message when loading a collection with an item of userdefined type 1
Sound repeats unending until closing workbook 2
ADO retrieval from close workbook-data type issue 2
Passing Information to and from Forms 10
question on scope of a global variable 1
passing values from form to module 5
Public Variables 5
User defined data type (losing its data) 2

Back
Top