Hello all,

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

Thanks,
Liam :o)

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.


--
Gary''s Student


"Liam" wrote:

Hello all,

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

Thanks,
Liam :o)

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


--
Gary''s Student


"Liam" wrote:

Hello all,

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

Thanks,
Liam :o)

Start here, just for example:

http://www.xcelfiles.com/Index.html
--
Gary''s Student


"John" wrote:

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


--
Gary''s Student


"Liam" wrote:

Hello all,

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

Thanks,
Liam :o)

Perfect. Thanks Gary.

John


"Gary''s Student" wrote in message
...
Start here, just for example:

http://www.xcelfiles.com/Index.html
--
Gary''s Student


"John" wrote:

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


--
Gary''s Student


"Liam" wrote:

Hello all,

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

Thanks,
Liam :o)

Start here, just for example:

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


--
Gary's Student


"John" wrote:

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


--
Gary''s Student


"Liam" wrote:

Hello all,

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

Thanks,
Liam :o)