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

[Gary''s Student]

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
>
>