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