Posted to microsoft.public.excel.programming

dunnerca

external usenet poster

Posts: 22

Unloading /Closing all userforms

I've searched all over and cannot find an example of coding that will close
all open user forms. I'm thinking something like

For i = 1 To Controls("msforms").Count
Unload ?
Next

As you can see, that's a really rough estimate of what's needed.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
Unloading userforms	Oggy	Excel Programming	6	May 13th 07 11:13 AM
Avoid unloading of .xla addins when closing books are cancelled.	Zoo	Excel Programming	4	February 21st 06 03:58 PM
Unloading / closing a form with the escape key	Bettergains	Excel Programming	0	January 11th 06 06:41 PM
Closing excel userforms	Jim[_57_]	Excel Programming	4	June 15th 05 05:27 AM
closing userforms	[email protected]	Excel Programming	5	May 11th 05 08:15 PM

All times are GMT +1. The time now is 06:37 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us