Select a cel on a worksheet

[Tadashii]

Hello,

Is there a function that when called, the user allow to select a cel on
a woorksheet and that the function returns the selected worksheet and
the selected cel (x,y position)?

Tadashii

 

[Guest]

I don't think that Select by single-click is possible. How about double-click:


Private Sub Worksheet_BeforeDoubleClick(ByVal _
Target As Range, Cancel As Boolean)
Cancel = True
MsgBox (Target.Address)
MsgBox (Target.Worksheet.Name)
End Sub


Put this in worksheet code, not a module.