Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
ShowModal = False gives improper form paint
I wrote a very simple VB routine to call an external program the reads
and writes info from/to the workbook. Prior to running the external program, I want to present the user with a status dialog box ("Program Executing. Standby...") so he's knows what is happening. I created the status Form and view it with ShowModal = True and it presented properly. However when I set ShowModal to False to allow the external program call while the Form is visible, the Form canvas was whited out. I thought maybe the Form was not given sufficient time to paint prior to launching the program. But adding a small delay between Form show and program launch did not fix the problem. Any ideas? Thanks Much, SteveM |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
ShowModal = False gives improper form paint
Try using the Repaint method on the form before running the external app.
That should force it to redraw. Although, if it's only just been displayed for the first time it shouldn't need to be redrawn, so that might not help. "SteveM" wrote: I wrote a very simple VB routine to call an external program the reads and writes info from/to the workbook. Prior to running the external program, I want to present the user with a status dialog box ("Program Executing. Standby...") so he's knows what is happening. I created the status Form and view it with ShowModal = True and it presented properly. However when I set ShowModal to False to allow the external program call while the Form is visible, the Form canvas was whited out. I thought maybe the Form was not given sufficient time to paint prior to launching the program. But adding a small delay between Form show and program launch did not fix the problem. Any ideas? Thanks Much, SteveM |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VBA always creates linked chart even when using PasteExcelTable False, False, False in Office 2007 | Excel Programming | |||
ShowModal = False but Textbox does not show on userform | Excel Programming | |||
ShowModal property | Excel Programming | |||
How to get ShowModal property | Excel Programming | |||
UserForm - ShowModal Error | Excel Programming |