Mouse Relocation to ActiveCell

**bstubbs** · 11-20-2009, 09:10 AM

I've got an application where I switch between workSheets and the mouse stays in the same location. As all of my actions are predicated on mouse right-clicks or double-clicks, the first thing that I have to do as move the mouse back to the active cell. Is there a way to reposition the mouse to the activeCell upon returning to the workSheet?

TIA.

Bob

**venkat1926** · 11-24-2009, 12:21 AM

suppose the active cell is A1 in sheet 1

right click the sheet1 tab and click viewcode and copypaste this code (modifyto suit you)

Please Login or Register  to view this content.

**teylyn** · 11-24-2009, 12:36 AM

venkat, that does not do anything with the mouse pointer at all! The OP wants to move the mouse pointer!

bstubbs, AFAIK things like this would involve the Windows32 API. See if this helps http://www.ozgrid.com/forum/showthread.php?t=32765

**bstubbs** · 11-27-2009, 10:01 AM

Yeah, I think that this will work for me. Thanks.

Next, since this works on screen coordinates, any ideas on how to determine the screen coordinates of the active cell?

Thanks.

Bob

**teylyn** · 11-27-2009, 10:04 AM

nice one. No clue. Maybe this is worth a new post to catch the attention of the knowledgeable VBA crew. Given it's a whole new ball game...

**romperstomper** · 11-27-2009, 10:37 AM

Have a look at the FormPositioner workbook available on Chip Pearson's site here.
In versions pre 2007, you can also create a zero sized chart at the cell location, activate it, use FindWindow (looking for an "EXCELE" class window) to get its handle and get the coordinates from that. Doesn't work for 2007 as the chart window doesn't exist any more unfortunately (though you can kludge it with sendkeys and finding the in-cell editing window.)

**bstubbs** · 11-27-2009, 05:15 PM

I got it to work using GetCursorPos and SetCursorPos functions, but I have to set variables for each such move. It will be a lot more flexible if I can just move the mouse to the activeCell of the activePage. Is there anyway to determine the xy(z?) coorinates of the activeCell?

Bob