ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Hourglass (https://www.excelbanter.com/excel-programming/324291-hourglass.html)

David

Hourglass
 
Hi Group,
Have a program that runs and sometimes takes a while with a large amout of
data. I have put the screenupdating to false, but would like an hour glass to
appear while the program is running. Any help would be appreciated.
Thanks,
--
David

RB Smissaert

Hourglass
 
Application.Cursor = xlWait

'do your long lasting code here

Application.Cursor = xlDefault

RBS


"David" wrote in message
...
Hi Group,
Have a program that runs and sometimes takes a while with a large amout of
data. I have put the screenupdating to false, but would like an hour glass
to
appear while the program is running. Any help would be appreciated.
Thanks,
--
David



David

Hourglass
 
Thank you. I appreciate your help.
Thanks,

"RB Smissaert" wrote:

Application.Cursor = xlWait

'do your long lasting code here

Application.Cursor = xlDefault

RBS


"David" wrote in message
...
Hi Group,
Have a program that runs and sometimes takes a while with a large amout of
data. I have put the screenupdating to false, but would like an hour glass
to
appear while the program is running. Any help would be appreciated.
Thanks,
--
David





All times are GMT +1. The time now is 10:06 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com