How can I display a progress indicator on a userform during a file save?

[Carl]

I'm attempting to display some form of message on an Excel
userform to show the users that the application hasn't
stopped during a file save, but I can't get anything to
display. I've even tried populating a field on the form
with a message, but it doesn't get displayed. However, if
I replace the save with a simple msgbox, the message does
get displayed on the userform. Anyone got any ideas?

 

[Andy Pope]

Hi Carl,

Have a look at this example,
(http://www.andypope.info/vba/pmeter.htm)

You probably need to use the doevents command to update any message you
have tried to display.

I'm attempting to display some form of message on an Excel
userform to show the users that the application hasn't
stopped during a file save, but I can't get anything to
display. I've even tried populating a field on the form
with a message, but it doesn't get displayed. However, if
I replace the save with a simple msgbox, the message does
get displayed on the userform. Anyone got any ideas?

--

Cheers
Andy

http://www.andypope.info

 

[roland]

Hi

try to use a userform which is opened as modeless
such as userform.show 0. This userform can show messages
and will stay active until the macro is finished.

kr roland

 

[Tushar Mehta]

In addition to Andy's suggestion, you might want to check my post in
'Progress of VBA macro' for a few ideas. That is the title of a
parallel discussion in the same newsgroup.

--
Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

 

[Guest]

Thanks guys!

-----Original Message-----
Hi

try to use a userform which is opened as modeless
such as userform.show 0. This userform can show messages
and will stay active until the macro is finished.

kr roland
.