View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Dick Kusleika[_4_] Dick Kusleika[_4_] is offline
external usenet poster
 
Posts: 595
Default Unloading a Form

VBA:

That error usually means you're trying to unload one of the controls rather
than form. For instance, in the userform's module

Unload Me.Multipage1

will produce that error, but

Unload Me

won't. Double check that you have the right object in your Unload
statement.

--
Dick Kusleika
MVP-Excel
www.dailydoseofexcel.com

VBA Fun wrote:
I have created many userforms and have been able to unload them.

I am wondering why I would get an error when I try to unload the
latest userform I am working with.

The error presented is run time error 361: Can't load or unload this
object

This form contains a Multipage where I add controls to several of the
pages. Could this be contributing to my problem? Is there something
that must be done prior to unloading this form?

I appreciate any input you could provide.