How does Userform get initialized by this?
 

Trying to figure out how a Userform gets initialized.
Found that this line of code in a normal module:

strINIPath = strLocalDrive & ":\Test.ini"

Initializes this Userform.

strINIPath and strLocalDrive are Public variables, declared in a normal
module and these
variables are not used in this Userform.


I test like this:

Set MainForm = Nothing

On Error Resume Next
Msgbox MainForm Is Nothing

strINIPath = strLocalDrive & ":\Test.ini"

Msgbox MainForm Is Nothing

The second messagebox will give False.


Thanks for any insight in this.


RBS

How does Userform get initialized by this?
 

If I had a userform named MainForm, then I received false for both message
boxes.

referencing a useform loads the userform.

To check if it is loaded, you have to loop through the userforms collection,
not check if it is nothing.

--
Regards,
Tom Ogilvy


"RB Smissaert" wrote in message
...
Trying to figure out how a Userform gets initialized.
Found that this line of code in a normal module:

strINIPath = strLocalDrive & ":\Test.ini"

Initializes this Userform.

strINIPath and strLocalDrive are Public variables, declared in a normal
module and these
variables are not used in this Userform.


I test like this:

Set MainForm = Nothing

On Error Resume Next
Msgbox MainForm Is Nothing

strINIPath = strLocalDrive & ":\Test.ini"

Msgbox MainForm Is Nothing

The second messagebox will give False.


Thanks for any insight in this.


RBS

How does Userform get initialized by this?
 

Just wondering why Mainform is not Nothing anymore after that line of code.
Maybe it is academic as I have no particular problem to solve, but just
trying to understand how this works.

RBS

"Tom Ogilvy" wrote in message
...
If I had a userform named MainForm, then I received false for both message
boxes.

referencing a useform loads the userform.

To check if it is loaded, you have to loop through the userforms
collection,
not check if it is nothing.

--
Regards,
Tom Ogilvy


"RB Smissaert" wrote in message
...
Trying to figure out how a Userform gets initialized.
Found that this line of code in a normal module:

strINIPath = strLocalDrive & ":\Test.ini"

Initializes this Userform.

strINIPath and strLocalDrive are Public variables, declared in a normal
module and these
variables are not used in this Userform.


I test like this:

Set MainForm = Nothing

On Error Resume Next
Msgbox MainForm Is Nothing

strINIPath = strLocalDrive & ":\Test.ini"

Msgbox MainForm Is Nothing

The second messagebox will give False.


Thanks for any insight in this.


RBS

How does Userform get initialized by this?
 

for me it was not nothing before that line of code.

--
Regards,
Tom Ogilvy

"RB Smissaert" wrote in message
...
Just wondering why Mainform is not Nothing anymore after that line of
code.
Maybe it is academic as I have no particular problem to solve, but just
trying to understand how this works.

RBS

"Tom Ogilvy" wrote in message
...
If I had a userform named MainForm, then I received false for both
message
boxes.

referencing a useform loads the userform.

To check if it is loaded, you have to loop through the userforms
collection,
not check if it is nothing.

--
Regards,
Tom Ogilvy


"RB Smissaert" wrote in message
...
Trying to figure out how a Userform gets initialized.
Found that this line of code in a normal module:

strINIPath = strLocalDrive & ":\Test.ini"

Initializes this Userform.

strINIPath and strLocalDrive are Public variables, declared in a normal
module and these
variables are not used in this Userform.


I test like this:

Set MainForm = Nothing

On Error Resume Next
Msgbox MainForm Is Nothing

strINIPath = strLocalDrive & ":\Test.ini"

Msgbox MainForm Is Nothing

The second messagebox will give False.


Thanks for any insight in this.


RBS

How does Userform get initialized by this?
 

Did you do: Set MainForm = Nothing ?

RBS

"Tom Ogilvy" wrote in message
...
for me it was not nothing before that line of code.

--
Regards,
Tom Ogilvy

"RB Smissaert" wrote in message
...
Just wondering why Mainform is not Nothing anymore after that line of
code.
Maybe it is academic as I have no particular problem to solve, but just
trying to understand how this works.

RBS

"Tom Ogilvy" wrote in message
...
If I had a userform named MainForm, then I received false for both
message
boxes.

referencing a useform loads the userform.

To check if it is loaded, you have to loop through the userforms
collection,
not check if it is nothing.

--
Regards,
Tom Ogilvy


"RB Smissaert" wrote in message
...
Trying to figure out how a Userform gets initialized.
Found that this line of code in a normal module:

strINIPath = strLocalDrive & ":\Test.ini"

Initializes this Userform.

strINIPath and strLocalDrive are Public variables, declared in a
normal
module and these
variables are not used in this Userform.


I test like this:

Set MainForm = Nothing

On Error Resume Next
Msgbox MainForm Is Nothing

strINIPath = strLocalDrive & ":\Test.ini"

Msgbox MainForm Is Nothing

The second messagebox will give False.


Thanks for any insight in this.


RBS