#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 266
Default Set Hourglass On

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


  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 5,934
Default 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.



  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 8,520
Default 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.


  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 266
Default 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.


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Why does the hourglass appear every time I hit "enter" in excel? brttdnzs New Users to Excel 0 October 22nd 08 10:20 PM
Display hourglass problems Dale Fye Excel Discussion (Misc queries) 2 November 29th 07 03:19 PM
How do I get rid of Hourglass Joe[_2_] Excel Discussion (Misc queries) 5 June 16th 07 08:50 PM
hourglass won't go away after formula was entered Dawn New Users to Excel 9 November 1st 05 10:36 PM
Hourglass comes up when going between split screens. jimbcpa Excel Worksheet Functions 4 August 27th 05 07:48 PM


All times are GMT +1. The time now is 11:53 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"