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