Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Form Initialized | Excel Programming | |||
Userform runs other subs when initialized | Excel Programming | |||
ImageList must be initialized | Excel Programming | |||
Excel: VBA userform is shown but not loaded/initialized even though it was first unloaded? | Excel Programming | |||
listbox value not initialized | Excel Programming |