Set Hourglass On
 

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

Set Hourglass On
 

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

--
Rick (MVP - Excel)


"dhstein" wrote in message
...
How can I set the hourglass to True - like in Access ? Thanks.

Set Hourglass On
 

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

If this post helps click Yes
---------------
Jacob Skaria


"dhstein" wrote:

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

Set Hourglass On
 

Jacob, Rick,

Thanks for the answer.



"Jacob Skaria" wrote:

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

If this post helps click Yes
---------------
Jacob Skaria


"dhstein" wrote:

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