fredlo2010
04-11-2014, 09:00 AM
Hi everyone,
I created a small user form ( very small: 2 labels, 2 checkboxes, 1 button) but every time I show it there is a small delay between showing the frame and the actual form contents, for about 3 seconds the user gets a windows frame filled with white. This is not a big deal but I would like to optimize it.
I have tried the following:
Loading the form when the workbook opens (then I will show it when needed)
Loading the form when the the first sub runs (then I will show it when needed)
Using repaint as soon as shows.
Enabling screeenupdating.
Any ideas on this?
This is the current code snippet:
Load frmType
frmType.Show
frmType.Repaint
Thanks a lot for the help :)
I created a small user form ( very small: 2 labels, 2 checkboxes, 1 button) but every time I show it there is a small delay between showing the frame and the actual form contents, for about 3 seconds the user gets a windows frame filled with white. This is not a big deal but I would like to optimize it.
I have tried the following:
Loading the form when the workbook opens (then I will show it when needed)
Loading the form when the the first sub runs (then I will show it when needed)
Using repaint as soon as shows.
Enabling screeenupdating.
Any ideas on this?
This is the current code snippet:
Load frmType
frmType.Show
frmType.Repaint
Thanks a lot for the help :)