Moving the Mouse...

J

JEB1123

Pardon my ignorance in such matters, but how do you move the mouse pointer to
a selected cell using a VBA Macro (code contained therein, following the
..Select)?

Thanking you in advance...
 
D

Don Guillett

Rarely necessary or desirable to select but
range("a4").select will take you there
or
application.goto sheets("sheet4").range("a4") to goto a cell on another
sheet.
 
J

Jim Thomlinson

To the best of my knoweldge you can not move the mouse pointer to the active
or selected cell (easily). The mouse pointer is controled by the operating
system and not by XL so anything you wanted to do would require an API call
which gets a bit tricky...
 
J

JEB

Jim. Thank you very much. That's what I thought. How about the MouseDown
event en XL? Would that work?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Choose which cell to paste data 5
retrieving cell reference data 4
how to move mouse using excel macro 2
Mouse Move Event 6
Highlight the row and the column that the mouse pointer is in. 1
Adding leading zeroes to selected alphanumeric cells 1
Mouse Pointer 1
using mouse click events in macros 3

Top