Display hourglass problems

D

Dale Fye

I have several areas within an Excel application where I want to display an
hourglass during a particular process. I have used the following, but the
cursor never changes to an hourglass. Is there some sort of refresh method
or something else I am supposed to do after setting the value to xlWait in
order to force the hourglass to appear?

Application.cursor = xlWait
'... some code here
Application.Cursor = xlDefault

Dale
 
D

Dale Fye

That seems to have helped.

Is that an Excel option that is available in the Tools->Options, that I have
not found?

Dale
--
Don''t forget to rate the post if it was helpful!

Email address is not valid.
Please reply to newsgroup only.


Frederik said:
Maybe Application.ScreenUpdating=True could help...
 

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

Top