Excel crashes when loading a large userform

[GVF]

The Autpen() sub runs fine and adds a menu to the Excel Commandbar.
Selecting commands brings up different Userforms. The small userforms come up OK.
Selecting the command that brings up the large userform (12 page multiform and 450 controls) crashes Excel. If I start the VBE first, there is no problem and everything runs fine.
That is an issue because I can't debug since if the VBE is running there are no errors. One time the "Sorry but I have to close now" dialog box indicated that the crash was in vbe6.dll.
Any suggestions?

(The large number of controls on the form are necessary to configure an array of 32 servos. Splitting the settings into different userforms is not acceptable for several reasons.)

 

[SkipVought]

Hi,

Don't know THE answer, but coinsider using ONE set of controls for all 32 servos, rather than 32 sets. Use a combobox to determine which servo is being configured/edited.

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[GVF]

Hi Skip,

Yea I started to do that but the program is set up to take position and speed settings from the slide controls and output in real time to the servos (using the scroll event) so the user can see what each movement is doing. It is real convenient to switch back and forth between multipages of servo controls and make an adjustment. This is a prototype project and I made the tradeoff to keep the background code simple by making the interface complex. If it gets beyond the proto stage I will break up the userform.

I wonder if it is just one control somewhere that has a slight corruption. Well, anyway, its usable but annoying.

Thanks,
Greg