Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 21
Default Forms blank out, periodically

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.

  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 860
Default Forms blank out, periodically

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]


bill wrote:
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.


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
printing blank forms with auto generated numbers Smurrock Excel Worksheet Functions 4 February 20th 09 07:29 PM
where can I down Blank Worksheets, blank stmt. of account forms carmen Excel Discussion (Misc queries) 2 January 15th 07 03:03 PM
How do I make fill-in-the-blank forms, with Excel? Raymond Mayo RJM ENT. New Users to Excel 1 August 15th 06 07:15 PM
Blank forms help! matt Excel Discussion (Misc queries) 2 February 13th 06 08:41 PM
Forms - Set Control Source to insert data in next blank row Vicki Henley Excel Programming 1 October 23rd 03 02:38 PM


All times are GMT +1. The time now is 04:02 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"