View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Peter T Peter T is offline
external usenet poster
 
Posts: 5,600
Default Mouse position within worksheet

That approach doesn't work in 2007+ as embedded charts are not windows in
they way they were in previous versions.

There are other ways of relating mouse coordinates to a cell address, or a
cell position to screen coordinates depending on the overall objective.

Regards,
Peter T

"Andrew" wrote in message
...
Some years ago I remember reading an approach for determining the
mouse position within a sheet. I believe this used the GetCursorPos
API to find the "absolute" mouse position relative to the window, then
inserted a dummy chart object in cell A1, set a handle to this and
then compared the coordinates of the chart to the mouse position to
determine its relative position on the sheet. I've spent about an
hour now searching for this code without success - does anyone have a
copy they could re-post?

Thanks a lot,
Andrew