Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations sizbut on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Change Excel mouse pointer

Status
Not open for further replies.

skipjakk

Technical User
Feb 25, 2002
18
US
I want to be able to change the mouse cursor to an arrow based on its location over an Excel range?
 
The shape of the cursor in Excel tells you information about what is going on. That's why they don't all change when you make a change in the control panel. I'd recommend against fiddling with it.

If you really want to change it, perhaps someone else here can tell you how. To be honest, I don't know.

[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ 181-2886 before posting.
 
What you're asking can be done with API, but there are pitfalls. Do a Google Groups search for "excel getcursorpos check range" (w/o quotes). Third option down and fourth option down will show you how to do what you are asking. If you use them, where they show the Address, check the address, i.e. ...

Code:
If Not Intersect(Range(YourFoundRangeHere), Range(RangeToLookInHere)) Is Nothing Then
'    Application.Cursor = xlDefault
    Application.Cursor = xlNorthwestArrow
'    Application.Cursor = xlIBeam
'    Application.Cursor = xlWait
Else
    Application.Cursor = xlDefault
End if

HTH

Regards,
Zack Barresse

Simplicity is the ultimate sophistication. What is a MS MVP? PODA
- Leonardo da Vinci
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top