Home |
Search |
Today's Posts |
#5
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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 |