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.
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.
Last edited by Jonathan78; 02-17-2012 at 09:41 AM.
Do you have any code in the checkboxes events?
Do you have any code behind the checkboxes? (eg in their Change events?)
Good luck.
Hello,
No I do not have any code behind the checkboxes yet
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.
I am going to use something like this for the checkboxes:
Please Login or Register to view this content.
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:
Initialize code:Please Login or Register to view this content.
CHeckbox code:Please Login or Register to view this content.
Please Login or Register to view this content.
Thanks Rory! That worked!
Glad to help. Please don't forget to mark the thread solved (see FAQ link at top of the page).
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks