"Unload Me" in 2010 Excel throwing Error

[jpk0920]

Hello,

"Unload Me" Showing error in 2010 VBA. can someone get alternative for "Unload Me"...?
in 2007 VBA "Unload Me" Is working fine.
for temp I'm Using "Me.Hide" Insteadof "Unload Me". Please help.

[Sisyphus]

Hi,
Have you tried both?

Code: Select all

Me.Hide
Unload Me


[jpk0920]

"Unload Me" i'm getting error. so i'm using "Me.Hide". "Me.Hide" working fine without any errors...

My question is is there any alternative for "Unload Me"...?
and
Why "Unload Me" showing error in 2010 VBA...?

Can you please give me a clear idea about this....

[Sisyphus]

Hi,
There are four steps to operating a form which you may want to keep an eye on: Load, Show, Hide and Unload.
On Load you load the form into memory but don't show it.
On Show the form becomes visible. You can't show a form that isn't loaded!
On Hide the form becomes invisible. If the form is modal the code will stop until you hide it.
On Unload the form is removed from memory. Obviously, you can't unload a form while it is showing, and be it only for the reason that you can't execute any code while it is still showing (except for code to operate the form EXCEPT to unload it).

Excel has grouped the Load action into the Show action, presuming that you want to load it since you expressed your wish to look at it. Quite possibly, Excel has done the same for the Unload event, presuming that you don't need to see it any more if you decide to unload it. For whatever reason, I suspect, Excel 2010 may not ahve inherited this presumptuousness and may insist that you hide the form before you can unload it.

There are many ways to load, show, hide and unload a form. They don't all function the same way and it is quite likely that some one will tell me it has always been this way or that and there is nothing new in Excel 2010 in this regard. For you, that kind of squabble doesn't matter because your problem is in that your form behaves differently from what you are used to. If you hide the form instead of unloading it you will not have a virgin form when you show it next. Data may have been retained in it and the initialize event won't fire. If you never unload it it will be unloaded when you close the application.

I hope that helps.