Forms blank out, periodically

[bill]

Workbook contains several forms of varying style
and function. One form shows the results of 10
recent tests in a countdown fashion, showing just
the results of one test, followed by a one-second
delay, followed by just the results of the second
test, and so on until the result of each of the
10 tests has been shown. Then the program
proceeds on to the next step by calling up a
different form. The problem . . .

Sometimes when the program starts running one or
two of the forms are blanked out ("white" with just
the top header showing). The forms continue to
function within the program but none of the graphics
are visible.

The next two or three times you run the program the
graphics are back; there is no regularity or pattern
associated with whether the forms act normally or not.

Don't understand what I am missing or need to do to
fix the problem. Any help very greatly appreciated.

 

[Jake Marx]

Hi bill,

You may want to add a DoEvents statement or invoke the Repaint method of the
UserForm every so often. It sound like your application is either in a
tight loop or is using up a lot of resources, so the UserForm is not
repainted during this time. DoEvents or Repaint may help the matter.

--
Regards,

Jake Marx
MS MVP - Excel
www.longhead.com

[please keep replies in the newsgroup - email address unmonitored]