How To Automatically Add Date And Time To Comments Using Button In Excel

How to Automatically Add Date & Time to Comments Using Button in Excel
By default, excel comments doesn’t have timestamp on comment. You can not add date & time to comments in excel. But adding date & time is really important. It helps us keeping track of things.

Now as it isn’t convenient to run vba code every time you need to create a comment so I’m going to create a button for you and assign the macro to it. From now whenever you press the button it will create a comment for you and each comment will be pre-populated with Author Name and Timestamp.

If you need to understand author name in comments and how to change them please check these videos:

Now without further ado lets follow the steps bellow to create comments with timestamp in excel using custom button.

Step 3: Click "Insert" and then "Module"
Step 5: Click On the "Run" Button
Done. It will create a comment and that comment will automatically have Date and time in it. Now you can use this just fine but if you want to add a button to it for a neat look you can do it. Please follow the below instructions to create a button and assign vba code to it.

Step 1: Click on “Insert” Menu
Step 2: Click on “Shapes”
Step 3: Select and draw your button shapes
Step 4: Give you button a name and format it according to your need.
Step 5: Now right click on the button and click on “Assign Macro”
Step 6: Done. Your button is ready.

Now all you have to do is select a cell and press the button. Now excel vba will create a comment for you and it will populate the comment will author name and timestamp.

#Timestamp #Comments
Thanks for watching.
-------------------------------------------------------------------------------------------------------------
Support the channel with as low as $5
-------------------------------------------------------------------------------------------------------------
Please subscribe to #excel10tutorial

Here goes the most recent video of the channel:

Playlists:

Social media:

[sininv]

hi there are so many links, I cannot see the code link. can you please advise the right code for this. thx

[tsTheKing]

can you send code? and how do i create a module (button) to populate selected cell with timestamp dd:mm:yy & hh:mm AM/PM

[SociallyAwkwardOne]

What’s the scripted I have signed up but not had any emails with the script

[khtoday]

How to link comment cell to other cell?