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
 
Top