How to Show HourGlass?
 

Hi

Is it possible to write a code to show a hourglass sign like in norma
windows application if the command button in a userform is clicked
bearing in mind that macro will be running...? so the hourglass shoul
appear once macro started and disappear once macro ends... kindl
advice...

cheer

--
hc
-----------------------------------------------------------------------
hce's Profile: http://www.excelforum.com/member.php...nfo&userid=351
View this thread: http://www.excelforum.com/showthread.php?threadid=26142

How to Show HourGlass?
 

Hi hce

Application.Cursor = xlWait
For the hourglass

Application.Cursor = xlDefault
To set it back to normal


--
Regards Ron de Bruin
http://www.rondebruin.nl


"hce" wrote in message ...

Hi

Is it possible to write a code to show a hourglass sign like in normal
windows application if the command button in a userform is clicked -
bearing in mind that macro will be running...? so the hourglass should
appear once macro started and disappear once macro ends... kindly
advice...

cheers


--
hce
------------------------------------------------------------------------
hce's Profile: http://www.excelforum.com/member.php...fo&userid=3518
View this thread: http://www.excelforum.com/showthread...hreadid=261425