Freeze user form while creating many dynamic controls

Anyone know how to freeze a userform while controls are being created by the VBA?

FreezeUserform
CreateDynamicControls
UnFreezeUserform

?

Originally Posted by Leith Ross

Hello richard.briggs,

I have never heard the term "freeze" used with respect to a UserForm. Can you explain what you mean by "freeze"?

Hi,
my form creates a lot of controls dynamically.

The form flickers a little while all the controls are being 'painted'.
The controls cannot be created in the initialise event as the number of controls depends on user selection of some criteria. It fear it could be more noticeable on a lower spec machine.

Therefore I am wanting to 'freeze' or stop output to the form until the routine has finished drawing the controls, then 'unfreeze' to show all the controls without flicker.

I have 'kind of' solved it in that I now make the parent frame invisible at the start then visible at the end, but still I have another use for freeze if you might know of a way.

Cheers

Richard

How many controls? I've added a lot of controls to a form before and never noticed it, though I suspect that it is possible. Is your code doing anything that may slow down the adding of them inadvertently? Can you post you code?

Sounds like you need a better solution, I'd rethink my design - can you post your workbook?