ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Unloading a Form (https://www.excelbanter.com/excel-programming/355260-unloading-form.html)

VBA Fun

Unloading a Form
 
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.
--
VBA Fun

VBA Fun

Unloading a Form
 
Nevermind....I found my problem. Nomenclature. For some reason I had my
form name in parenthesis.
--
VBA Fun


"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.
--
VBA Fun


Dick Kusleika[_4_]

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.





All times are GMT +1. The time now is 07:25 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com