Mouse Location, Movement and Spreadsheet Location

[TCook]

Hello All,

Here is what I am trying to do:

From within Excel, as the user moves the mouse over certain cells, I wish to
display certain information.

I am very familiar with Excel's spreadsheet selection events and these are
not appropriate. It will not be based upon selections.

I am also familiar with the GetCursorPos API. The problem is that when I
try to use this against a cell location, the cell positioning is according
to its location within the Excel window whereas the GetCursorPos is against
the entire screen.

I know that this can be done because as one moves the mouse over cells
within a spreadsheet, the mouse icon changes accordingly. This is native
Excel functionality and is exactly what I am trying to emulate.

Does anyone have any idea how to detect which cell(s) the mouse is moving
over at any given time from within Excel?

Thanks & Regards,

Todd

 

[Tom Ogilvy]

someone posted this in answer to a similar requirement:

http://www.mrexcel.com/board2/viewtopic.php?t=164682&highlight=mouse+location

 

[TCook]

Hey Tom,

Thanks for the info.

Regards,

Todd

someone posted this in answer to a similar requirement:

http://www.mrexcel.com/board2/viewtopic.php?t=164682&highlight=mouse+location

 

[Someone]

The sample uses SetWindowsHookEx() with WH_MOUSE_LL hook, which requires
Windows NT4/2000/XP+, use WH_MOUSE or any other suitable one instead.

http://msdn.microsoft.com/library/d...kreference/hookfunctions/setwindowshookex.asp