Moving the Mouse...
 

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...
--
John

Moving the Mouse...
 

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.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

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

Moving the Mouse...
 

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...
--
HTH...

Jim Thomlinson


"JEB1123" wrote:

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...
--
John

Moving the Mouse...
 

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

"Jim Thomlinson" wrote:

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...
--
HTH...

Jim Thomlinson


"JEB1123" wrote:

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...
--
John