Hi everyone:

In excel, I have created an user form that may perform a rather long
process. So, I want to disable Excel, and change the mousepointer to
Hourglass. When done, change the mousepointer back to default, and enable
Excel. Does anyone know how to do this? I appreciate a code. Thanks for
all your help.

Bob

How about you leave the userform open, maybe with a label control that
displays "Working" prominently?

--
Jim
"Bob" wrote in message
...
| Hi everyone:
|
| In excel, I have created an user form that may perform a rather long
| process. So, I want to disable Excel, and change the mousepointer to
| Hourglass. When done, change the mousepointer back to default, and enable
| Excel. Does anyone know how to do this? I appreciate a code. Thanks for
| all your help.
|
| Bob
|
|

This will work for you!

Sub YourProcedure()

Application.Cursor = xlWait

'your code here

application.Cursor = xlDefault

End Sub

Hope this helps! If so, let me know or click "Yes" below.
--
Cheers,
Ryan


"Bob" wrote:

Hi everyone:

In excel, I have created an user form that may perform a rather long
process. So, I want to disable Excel, and change the mousepointer to
Hourglass. When done, change the mousepointer back to default, and enable
Excel. Does anyone know how to do this? I appreciate a code. Thanks for
all your help.

Bob

Thank you Ryan. I did not know Application has a Cursor property.

Bob

"RyanH" wrote in message
...
This will work for you!

Sub YourProcedure()

Application.Cursor = xlWait

'your code here

application.Cursor = xlDefault

End Sub

Hope this helps! If so, let me know or click "Yes" below.
--
Cheers,
Ryan


"Bob" wrote:

Hi everyone:

In excel, I have created an user form that may perform a rather long
process. So, I want to disable Excel, and change the mousepointer to
Hourglass. When done, change the mousepointer back to default, and
enable
Excel. Does anyone know how to do this? I appreciate a code. Thanks
for
all your help.

Bob

You can go to the Object Browser in VBE and see all the properties, methods,
and events for all objects.

Hope this helps! If so, click "Yes" below.

--
Cheers,
Ryan


"Bob" wrote:

Thank you Ryan. I did not know Application has a Cursor property.

Bob

"RyanH" wrote in message
...
This will work for you!

Sub YourProcedure()

Application.Cursor = xlWait

'your code here

application.Cursor = xlDefault

End Sub

Hope this helps! If so, let me know or click "Yes" below.
--
Cheers,
Ryan


"Bob" wrote:

Hi everyone:

In excel, I have created an user form that may perform a rather long
process. So, I want to disable Excel, and change the mousepointer to
Hourglass. When done, change the mousepointer back to default, and
enable
Excel. Does anyone know how to do this? I appreciate a code. Thanks
for
all your help.

Bob