How can I get current position of "cursor"?

===========
Hi,

Enter a line

curloc = activecell.address

into your macro.

This will return the current cell value as "$A$3" if your cursor was in cell A3.

Hope this helps
Sean

========

If you need the actual cursor position and not the postion of the highlighted cell here's quick example of the GetCursorPos API call.

First, create a user form and add a commandbutton to it. Then add this code to the userform:

Private Type POINTAPI
x As Long
y As Long
End Type

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

Dim pos As POINTAPI ' Declare variable

Private Sub CommandButton1_Click()
GetCursorPos pos ' Get Co-ordinates
MsgBox "Cursor Pointer is at:" & vbNewLine _
& "x:=" & pos.x & vbNewLine _
& "y:=" & pos.y
End Sub

Run the userform and when you click on the button you will be told where the cursor is.

Hope this is helpful.

========