Finding cell that a user click?

C

crapit

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

Frank Kabel

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 :)
 
C

crapit

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
 
Top