Forms load very slowly

[klorentzen]

I have a workbook that utilizes several userforms to make changes throughout the workbook. Forms with just a few objects open (show) quickly, but forms with a large number of gadgets take up to 30 seconds to display. I have verified that none of my code is executing during the wait, so it's simply the loading of the form that is taking the time (in fact if I just hide and unhide it, it immediately begins executing my code).
Any ideas on how to speed this up? (BTW, Intel E8400 Core2 Duo, 4 Gig RAM, fresh install of Windows 7 Pro)

Thanks,

Kurt

 

[Norie]

Kurt

I assume by 'gadgets' you mean controls?

Do you have any code in the initialize/activate event of these userforms?

 

[klorentzen]

Yes, the "gadgets" include about 160 checkboxes, a combo box, 3 radio buttons and the usual OK|Cancel exit buttons.

I do have code in the activate event which I flagged so I could watch it execute. that code doesn't begin to execute for about 30 seconds, so I have to assume it's VBA initializing the form that's taking alll the time. The ComboBox has code in the exit event that executes instantly once the form is loaded, and code very similar to the activate code executes in maybe 1 second when the "OK" button is selected (The activate event code reads from the worksheet and assigns values to the checkboxes, radio buttons, etc. The exit code does just the opposite, filling cells with whatever changed on the form).

Thanks,

Kurt