Checkboxes on Userform Cause Flickering

[Jonathan78]

Hello all,

The checkboxes on my userform cause a lot of screen flickering upon opening.
I tried Application.ScreenUpdating = False, but that didn't work.

Please Login or Register  to view this content.

[Andy Pope]

Do you have any code in the checkboxes events?

[OnErrorGoto0]

Do you have any code behind the checkboxes? (eg in their Change events?)

[Jonathan78]

Hello,
No I do not have any code behind the checkboxes yet

[OnErrorGoto0]

Do you have any controls linked directly to cells? At the time the Initialize event fires, the form isn't even visible, so I am not sure what could be causing the flickering. Seeing the workbook might help.

[Jonathan78]

I am going to use something like this for the checkboxes:

Please Login or Register  to view this content.

[OnErrorGoto0]

If you already have that code in there, that is the cause - when you set the values of the checkboxes, it is equivalent to clicking them. If you don't want to run that code when loading the form, you need a module level Boolean variable that you set to true, then check that variable in the first line of the checkbox code:

Top of userform:

Please Login or Register  to view this content.

Initialize code:

Please Login or Register  to view this content.

CHeckbox code:

Please Login or Register  to view this content.

[Jonathan78]

Thanks Rory! That worked!

[OnErrorGoto0]

Glad to help. Please don't forget to mark the thread solved (see FAQ link at top of the page).