Detect cell address of cell directly under mouse pointer

[Jbentley]

Hi,
I've a sheet that presents the profitability of sales locations in a geographic layout (similar to Tables in a restaurant), each sales location is a cell, with roughly 1,600 locations presented. Each location is colour coded based on performance / measure, in a basic thermographic way [e.g. dark blue for very poor, solid red for high performance] with users being able to change metrics and re-colour cells accordingly.

The sheet is already information rich, but I'm wanting to detect the cell address directly under the pointer and populate a text box or other cell based on the value in the cell directly below the mouse pointer.

My question is; Is there a simple way of detecting the mouse position on the XL Grid? nb. Want to avoid having to activate cell beneath pointer.


Any advice greatly appreciated.

[JeanRage]

Hi,

Could the cell comment be part of the solution ...?

HTH

[JeanRage]

For the sake of an initial test ...

Please Login or Register  to view this content.

HTH

[Jbentley]

Thanks for the advice JeanRage.
I'm hoping to avoid activating the cell(s) beneath the pointer.
I've looked at some the methods for calculating mouse x/y co-ords which might look promising except that where the Xl grid is scrolled the x/y is only calculated from the top left of the screen & not top left of xl grid..

Hoping to add the output to a dashboard without letting users trash it.
Locking cells might be the answer..

[romperstomper]

Your problem is going to be detecting the mouse movement to update the textbox, I think, which will basically involve subclassing the Excel window (not for the faint hearted).

[JeanRage]

Thanks for the advice JeanRage.
I'm hoping to avoid activating the cell(s) beneath the pointer.
I've looked at some the methods for calculating mouse x/y co-ords which might look promising except that where the Xl grid is scrolled the x/y is only calculated from the top left of the screen & not top left of xl grid..

Hoping to add the output to a dashboard without letting users trash it.
Locking cells might be the answer..

Hi,
You do not have to activate the cell beneath the pointer in order to read the comment attached to the cell located beneath the pointer ...

HTH

[Jbentley]

Hi,
Thanks both.
I am of the faint hearted when it comes to intracies of vba so think I'll leave that one alone - maybe in some distant future when I upskill.

I'll be wanting to dynamically change the 'text' dependending on various user selections, and do not necessarily want to update 1,600 comment boxes each time.

Cheers