VBA to position my mouse cursor on my desired spot on screen

[Edmund]

How can I tell VBA to position my mouse cursor at my desired point on screen?

Certain applications (non MS Office) in my desktop does not support
navigation using keyboard punches (eg Ctrl+Right Arrow to select its next
tab). Therefore, I need to tell "VBA to go to a certain position on the
screen". When this is achieved, I will use sendkey (SendKeys "~", True) wrap
up the task.

Pls show me some sample codes. I will adjust the X & Y value to my desired
position.

Edmund
Using Excel 2000

 

[Tom Ogilvy]

the mouse position really has no effect on where SendKeys are sent. They
are sent to the activewindow. You would need to use the Windows API to
bring your window to the foreground and then do the sendkeys.

this code might give you some ideas:

http://vbnet.mvps.org/index.html?code/helpers/restorehwnd.htm

 

[NickHK]

Edmund,
Depending on what these "certain applications" are, the FindWindow,
FindWindowEx and SendMessage may be a more reliable method.

NickHK