Mouse Location, Movement and Spreadsheet Location
 

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

Mouse Location, Movement and Spreadsheet Location
 

someone posted this in answer to a similar requirement:

http://www.mrexcel.com/board2/viewto...mouse+location

--
Regards,
Tom Ogilvy


"TCook" wrote in message
...
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

Mouse Location, Movement and Spreadsheet Location
 

Hey Tom,

Thanks for the info.

Regards,

Todd


"Tom Ogilvy" wrote in message
...
someone posted this in answer to a similar requirement:

http://www.mrexcel.com/board2/viewto...mouse+location

--
Regards,
Tom Ogilvy


"TCook" wrote in message
...
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

Mouse Location, Movement and Spreadsheet Location
 

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/de...dowshookex.asp



"Tom Ogilvy" wrote in message
...
someone posted this in answer to a similar requirement:

http://www.mrexcel.com/board2/viewto...mouse+location

--
Regards,
Tom Ogilvy


"TCook" wrote in message
...
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