View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Gary''s Student Gary''s Student is offline
external usenet poster
 
Posts: 11,058
Default Select a cel on a worksheet

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