Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I refresh a form in excel?
Excel 9
H I have some code in excel that opens work and exceutes a mailmerge. Whilst the code is executing, I thought it would be nice to have a simple form which tells the user that the mailmerge is being processed. The problem is that design of the form disappears and all you can see is the outline. I've tried looking for a timer control but I don't have one on my PC and I can't download anyting as I'm at work Is there anything that I can do that will kep the form refreshed whist the code is executing? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I refresh a form in excel?
you must be using a loop of some kind.
Within the loop add these two lines Me.Refresh DoEvents Patrick Molloy Microsoft Excel MVP -----Original Message----- Excel 97 Hi I have some code in excel that opens work and exceutes a mailmerge. Whilst the code is executing, I thought it would be nice to have a simple form which tells the user that the mailmerge is being processed. The problem is that design of the form disappears and all you can see is the outline. I've tried looking for a timer control but I don't have one on my PC and I can't download anyting as I'm at work. Is there anything that I can do that will kep the form refreshed whist the code is executing? . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy Excel functions formula and auto refresh refresh | Excel Worksheet Functions | |||
Change and refresh OLEObject showing Excel chart on Access form. | Charts and Charting in Excel | |||
Form will not refresh without an unneeded msgbox | Excel Programming | |||
Pivot Table REFRESH Flaw -- Saves Old Data in Selection Area AFTER REFRESH | Excel Programming | |||
Excel does not close from VB!! (when i refresh Refresh query with BackgroundQuery:=False) | Excel Programming |