How to Show HourGlass?

  • Thread starter Thread starter hce
  • Start date Start date
H

hce

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
 
Hi hce

Application.Cursor = xlWait
For the hourglass

Application.Cursor = xlDefault
To set it back to normal
 
Back
Top