I'm creating progressively more complex multi-form applications using
Excel Userforms, and am finding that they sometimes have stability
issues - sometimes completely crashing Excel.
Has anyone else experienced problems with these and can recommend ways
of ensuring stability?
TIA
mark

The first thing I would try is to clean the VBA Project using Rob
Bovey's CodeCleaner add-in. When you do a lot of editing over a long
period of time, VBA's internal code storage gets junked up with a lot
of extraneous and invalid code. It is nothing you did or any problem
with your existing code; it is a problem with the internals of VBA.

Rob's add-in exports all the VBA code to text files, purges the
existing VBA from the project, and then imports the text files back
into the project. While this can be done manually, the CodeCleaner
reduces it to a mouse click. CodeCleaner is one of the essential
add-ins that every developer should have in his arsenal. It can cure
any number of problems.

Go to www.appspro.com then the Free Utilities page and download the
latest version of the Code Cleaner.

Cordially,
Chip Pearson
Microsoft MVP
Excel Product Group
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)


On Mon, 1 Dec 2008 06:38:34 -0800 (PST), dransfield
wrote:

I'm creating progressively more complex multi-form applications using
Excel Userforms, and am finding that they sometimes have stability
issues - sometimes completely crashing Excel.
Has anyone else experienced problems with these and can recommend ways
of ensuring stability?
TIA
mark