Solved

Destroying a Collection of UserForms

Posted on 2007-03-19
2
219 Views
Last Modified: 2010-04-30
If I set a collection of userforms = to Nothing, are the forms it contains automatically unloaded and removed from memory, or should I unload them one by one before I destroy the collection?

Mike
0
Comment
Question by:shacho
2 Comments
 
LVL 8

Accepted Solution

by:
KelvinY earned 500 total points
ID: 18746958
VBA does not manage memory the way that .NET does, so you are responsible for destroying the objects that you create. You should unload the forms first and then destroy the collection. If you don't then they will hang around consuming until the application ends.
0
 

Author Comment

by:shacho
ID: 18761214
Thanks for the info!

Mike
0

Featured Post

Live: Real-Time Solutions, Start Here

Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
If you need to start windows update installation remotely or as a scheduled task you will find this very helpful.
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

813 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now