ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   modeless dialog question (https://www.excelbanter.com/excel-programming/378916-modeless-dialog-question.html)

Gary Keramidas

modeless dialog question
 
i'm sure it's been asked before, but i am trying to display a form while i build
a report, but all that's visible is he form caption. it works good enough if i
put the message in the caption, but why does the form show a white background
and no label when it is displayed?

--


Gary




NickHK

modeless dialog question
 
Gary,
If you are running intensive code, you may not be giving Excel the
opportunity to repaint the form. Adding a DoEvents in a suitable place will
yield some time to other causes.

NickHK

"Gary Keramidas" <GKeramidasATmsn.com wrote in message
...
i'm sure it's been asked before, but i am trying to display a form while i

build
a report, but all that's visible is he form caption. it works good enough

if i
put the message in the caption, but why does the form show a white

background
and no label when it is displayed?

--


Gary






Gary Keramidas

modeless dialog question
 
thanks, nick. worked fine

--


Gary


"NickHK" wrote in message
...
Gary,
If you are running intensive code, you may not be giving Excel the
opportunity to repaint the form. Adding a DoEvents in a suitable place will
yield some time to other causes.

NickHK

"Gary Keramidas" <GKeramidasATmsn.com wrote in message
...
i'm sure it's been asked before, but i am trying to display a form while i

build
a report, but all that's visible is he form caption. it works good enough

if i
put the message in the caption, but why does the form show a white

background
and no label when it is displayed?

--


Gary









All times are GMT +1. The time now is 11:55 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com