Jim:
Thank you for your response. I like your version better than mine - 1 less
line of code.
After Norman suggested changing the cursor form, I looked "cursor" up in VBE
Help. From the choices, I selected the xlNorthwestArrow since the tester & I
were expecting to see an arrow instead of an hourglass. I then reset the
cursor to the default since VBE Help said to do so.
What I haven't been able to figure out (after researching VBE Help, Google,
the Microsoft website, & my 3 ref books) is the following:
1) What does the "default" cursor mean? I can't find an option in Excel to
change the appearance of the cursor. Is it referring to the user's selection
in Control Panel | ... | Mouse | Pointers tab | Customize?
2) If that is the case, why does "Application.Cursor" work in an Excel macro
when Application (per VBE Help) refers to the Excel application, but the
Control Panel isn't the Excel application? Have I totally misunderstood VBA
basics?
Thank you for any clarification you can provide.
Elizabeth


"Jim Cone" wrote:

Norman,

I once had a user sit and start at a Msgbox waiting for the hourglass to stop.
Ever since then, I change the cursor to the default before showing a Msgbox...
Elizabeth could change her code to...

Sub StartupPath()
Application.Cursor = xlDefault
MsgBox Application.StartupPath, Title:="The Excel startup path is: "
End Sub

Jim Cone
San Francisco, USA


"Norman Jones"

wrote in message
...

Hi Elizabeth,
Running your procedure from Excel (either via Alt-F8 or from a rectangle,
to simulate your scenario), I get the hourglass, indicating that the macro
is waiting for user response. Running the macro manually from the VBE, I get
the arrow cursor.
If you find this disconcerting, you could specify the cursor form.
I guess that, in analagous situations, the curssor form has never adversely
impinged for me.---
Regards,
Norman