How to Show HourGlass?

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
 
R

Ron de Bruin

Hi hce

Application.Cursor = xlWait
For the hourglass

Application.Cursor = xlDefault
To set it back to normal
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I get the hourglass to show? 5
Msg Box to Appear?? 2
Help with DoEvents to show progress form, please? 1
Userforms: Disabling - Enabling the X 4
Adapting your Unique Value method Attn: Ron de Bruin 1
pause a macro to display a form for x seconds then end 2
URGENT help needed for a macro to place and size command button 7
Can't get hourglass to work 3

Top