View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming,microsoft.public.vb.winapi,microsoft.public.win32.programmer.ui
Someone Someone is offline
external usenet poster
 
Posts: 2
Default 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