P
Paul
Has anyone had any success capturing pointer locations
within Excel? According to "MouseDown, MouseUp Events"
within Help, when you click on "Applies To", both events
should apply to a UserForm, so the following should allow
you to capture the pointer location of a UserForm:
Private Sub UserForm_MouseDown(Button, Shift, X, Y)
MsgBox X
MsgBox Y
End Sub
However, this does not work, and when you read Help
for "MouseDown" alone, it supposedly only applies to a
chart object.
I would like to capture the mouse location on a
spreadsheet and also a UserForm, so has anyone been able
to do this?
Regards
Paul
within Excel? According to "MouseDown, MouseUp Events"
within Help, when you click on "Applies To", both events
should apply to a UserForm, so the following should allow
you to capture the pointer location of a UserForm:
Private Sub UserForm_MouseDown(Button, Shift, X, Y)
MsgBox X
MsgBox Y
End Sub
However, this does not work, and when you read Help
for "MouseDown" alone, it supposedly only applies to a
chart object.
I would like to capture the mouse location on a
spreadsheet and also a UserForm, so has anyone been able
to do this?
Regards
Paul