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
|