Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 5
Default 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
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 5
Default 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

  #3   Report Post  
Posted to microsoft.public.excel.programming
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.



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Form not unloading before next code line Michael Beckinsale Excel Programming 4 January 11th 06 01:26 PM
Strange issue freezing parent form when unloading a child form Stefano Gatto Excel Programming 1 November 11th 05 04:42 PM
Unloading a form using the ESC key johncassell[_24_] Excel Programming 2 August 16th 05 06:19 PM
How to avoid re-initialisation when Unloading form count Excel Programming 4 December 14th 04 03:58 PM
Unloading A Form Chrissy[_4_] Excel Programming 1 October 15th 03 02:17 PM


All times are GMT +1. The time now is 12:22 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"