How can you change the Mouse cursor/icon when it is over a certain range of cells in Excel. There isn't a mouse mouse event so is this possible? Much appreciate any guidence on this.
Thanks

Gavin,

This can't be done in Excel VBA.

In theory you could subclass Excel to try to trap the MOUSEMOVE windows messages, then test to see whether the current mouse co-ordinates are the same as your set of special cells and in in which case set the mouse icon accordingly. In practice, however, subclassing Excel in VBA rarely works as VBA is too slow to process all the messages and Excel tends to crash.

If you were really desparate to get this sort of functionality then you could try looking at writing some custom add-ins for excel in VB / C++ but you're getting a bit out of my depth there and it will be a lot of work to achieve the effect.

HTH,
Maccas

Thanks for this. What about .net ie: Office Studio. Would this be possible to develop this functionality in that. I have seen other application that use Excel for their front-end, where they are able to control the mouse icon as it moves to a particular cell location. I suppose this was developed in their add-ins ie: C# or similar. Any further clues would be great help on this journey for enlightenment.

Thanks

Absolutely. I've not actually tried to use VS.Net but I understand that you can create compiled code that will handle windows messages thereby allowing you to determine when the mouse moves over a certain set of cells.

Since I've not tried this I can't help you much more but I would suggest that if your only programming experience is with VBA then you might find VB.Net easier to pick than C#.Net. They can both, ultimately, do the same things.