Finding cell that a user click?
 

Is the event Worksheet_SelectionChange(ByVal Target As Range) the only way
to detect which particular cell a user has clicked?

Finding cell that a user click?
 

Hi
if you want an automatic response directly after the
selection change, then yes. If you want the current
selected cell within a mayro you can always use
msgbox activecell.address

But maybe you can explain what you're trying to do and why
the worksheet_event won't work for you :-)

-----Original Message-----
Is the event Worksheet_SelectionChange(ByVal Target As
Range) the only way
to detect which particular cell a user has clicked?


.

Finding cell that a user click?
 

When a user select a certain range of cell, the date and time picker will
appear. But somehow, the size of the Date and Time Picker did not appear
correctly
"Frank Kabel" wrote in message
...
Hi
if you want an automatic response directly after the
selection change, then yes. If you want the current
selected cell within a mayro you can always use
msgbox activecell.address

But maybe you can explain what you're trying to do and why
the worksheet_event won't work for you :-)

-----Original Message-----
Is the event Worksheet_SelectionChange(ByVal Target As
Range) the only way
to detect which particular cell a user has clicked?


.