ExcelBanter

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

K[_4_]

Hourglass
 
hello,
I've forgotten, and can't find in help, how to turn on the
hourglass using VBA in a function.
any suggestions?

K

Chip Pearson

Hourglass
 
Use

Application.Cursor = xlWait


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"K" wrote in message
...
hello,
I've forgotten, and can't find in help, how to turn on the
hourglass using VBA in a function.
any suggestions?

K




K[_4_]

Hourglass
 
Hi Chip,

That's an approach that I haven't seen before.
How do I turn it off after the process is complete?

K
-----Original Message-----
Use

Application.Cursor = xlWait


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"K" wrote in message
...
hello,
I've forgotten, and can't find in help, how to turn on

the
hourglass using VBA in a function.
any suggestions?

K



.


Chip Pearson

Hourglass
 
To return the cursor to its default setting, use

Application.Cursor = xlDefault


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"K" wrote in message
...
Hi Chip,

That's an approach that I haven't seen before.
How do I turn it off after the process is complete?

K
-----Original Message-----
Use

Application.Cursor = xlWait


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"K" wrote in message
...
hello,
I've forgotten, and can't find in help, how to turn on

the
hourglass using VBA in a function.
any suggestions?

K



.





All times are GMT +1. The time now is 04:07 AM.

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