MsgBox or PostMsg?

J

jmac60

I have a macro that takes about 30 seconds to process, and want to put up a
message telling the users to wait (like the hour glass icon) while the macro
runs so they dont keep clicking the 'Save' button.
MsgBox doesn't work because you have to click through it and then it
disappears.
I can't find any documentation on PostMsg other than it exists.
Is there a function I can use?
thanks
 
B

Bear

JMac60:

Have you considered just changing the cursor to an hourglass?

System.Cursor = wdCursorWait
' Your processing here
System.Cursor = wdCursorNormal

Bear
 
J

jmac60

Beautiful...I didn't know that could be done...too bad it doesn't spin.

Thanks a bunch
 
B

Bear

JMac60:

It's fabulous when something works out more simply than one expected. Thanks
for rating the post.

Bear
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top