Position of the mouse pointer

[Liam]

Hello all,

How would i get VB to report the position of the mouse pointer?

Thanks,
Liam )

 

[Gary''s Student]

Declare Function GetCursorPos Lib "user32" _
(lpPoint As POINTAPI) As Long


Type POINTAPI
X As Long
Y As Long
End Type


Sub ShowPos()
Dim lRetVal As Long
Dim Pos As POINTAPI
lRetVal = GetCursorPos(Pos)
MsgBox Pos.X & ", " & Pos.Y
End Sub


The mouse doesn't even need to be in the application window.

 

[John]

Hi Gary,

Do you know of a good web source for details of calling Windows API
functions from VBA?

Best regards

John

 

[Gary''s Student]

Start here, just for example:

http://www.xcelfiles.com/Index.html

 

[John]

Perfect. Thanks Gary.

John

Start here, just for example:

http://www.xcelfiles.com/Index.html

 

[Gary''s Student]

Start here, just for example:

http://www.xcelfiles.com/Index.html