Is there a flag that indicates a userform is being initialized?

[DanCarlson]

When my userform initializes i fill several comboboxes, list boxes, etc. which triggers a _Change event for these objects invoking their _Change routines. Is there a flag that indicates the userform is being initialized? If so, it could be used to skip the _Change event routines while initializing. Or is there another means to ignore Change events during initialization?

 

[jkpieterse]

Just add a module-level variable to your forms module:

Private mbInit As Boolean

At the start of your init routine you set it to True and at the end to False. Then in each relevant event stub you add:

If mbInit Then Exit Sub

 

[DanCarlson]

Thats works... THanks Jan!