Set Hourglass On

[dhstein]

How can I set the hourglass to True - like in Access ? Thanks.

 

[Rick Rothstein]

I'm guessing you mean the mouse cursor on the screen, right? You can change
it to the "hourglass" (it is a spinning circle on my Vista system by the
way) using this line of code...

Application.Cursor = xlWait

But keep in mind it will remain the "hourglass" symbol until you change it
back using this line of code..

Application.Cursor = xlDefault

 

[Jacob Skaria]

Application.Cursor = xlWait
'---do something
Application.Cursor = xldefault

If this post helps click Yes

 

[dhstein]

Jacob, Rick,

Thanks for the answer.

Application.Cursor = xlWait
'---do something
Application.Cursor = xldefault

If this post helps click Yes