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.
--
Gary''s Student
"Tadashii" wrote:
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
--
Tadashii
------------------------------------------------------------------------
Tadashii's Profile: http://www.excelforum.com/member.php...o&userid=23918
View this thread: http://www.excelforum.com/showthread...hreadid=513643