Label to display current Date, Time

[robbert]

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

Please Login or Register  to view this content.

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

[shg]

Shape or a label from the Forms toolbar:

Please Login or Register  to view this content.

ActiveX object or a label from the Control Toolbox:

Please Login or Register  to view this content.

[robbert]

Works great, thank you