Hello,

I have a button on my sheet and when the user presses it I want my Label to display the current Date & Time. This will allow the user to
a) know when the sheet was last updated and
b) communicate that the button was pushed and the data was updated successfuly.

I know this is super easy but don't know the exact code, here is what I have included in my command button click subroutine.....

ActiveSheet.Shapes("Label1").Caption = Now
What's incorrect with this? And also, how can I modify the date & time formatting, or where can I learn how to do that?

Thank you so much,
Robert