How to Insert Date and Time if a Checkbox is Checked in Excel

*How to Insert Date and Time if a Checkbox is Checked in Excel*

In this advanced excel tutorial, I’ll explain how to add timestamp whenever you check a checkbox in excel. Recently I finished a project where I was asked to create a to do list that has 3 features.
1. Serial number should be placed automatically whenever I write something in the to-do list
2. Creating checkboxes in bulk.
3. Whenever the checkbox is checked, date and time should be automatically placed in the next column. Also, timestamp shouldn’t change whenever we open or calculate the workbook.

Now comes the last part, how to insert timestamp automatically whenever a checkbox is clicked in excel.

I assume you’ve created Form Control Checkbox using the technique I stated earlier. Now follow the below steps to automatically add date and time when someone checkmark a checkbox.

*Step 2:* Click on Visual Basic, Insert and then Module.
*Step 4:* Close the VBE
*Step 5:* Now Click on the Page Layout Tab and then Selection Pane. It will open selection pane from the right of your workbook.
*Step 6:* Select all the checkboxes you want to add timestamp to.
*Step 7:* Right-click on any checkbox from the worksheet and click on assign macro.
*Step 8:* Select the macro named CheckBox_TimeStamp
*Step 9:* Now click ok and done. It will automatically add date and time of checking the checkmark to the next cell.

Remember to save the workbook as .xlsm format for future use. This is how you add timestamp in excel whenever a Form Control Checkbox is checked in excel.

#TimeStamp #Checkbox #VBA #Excel

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:

[Exceltutorial]

Recommend WPS Office-Best FREE alternative to Microsoft Office, Download for Win & Mac & Mobile.

[ocedzyx]

You sir, just solved a massive issue I was having not being able to use Google Sheets.

[petermarcussen]

Great video, is there a way to auto add account name in a cell aswell?

[AmandeepSingh-yixr]

Sir while i apply filter in check box excel sheet .check boxes are overlaped.

[tonydiulio]

Not sure if this is still being reviewed but what would I need to change in the macro to get the date and time to be inserted in the cell below the checkbox rather than to the right of the checkbox? Thank you for all your help, this was a great video

[rajeevakumardubey]

Dear I’m unable to fix how to lock columns on dates, I watch your video but not resolved the issue

[miaaTOOfine]

How do you add the marco time stamp tho? How did you create it?

[lalu]

Can this be done i na separate sheet ? I mean, when you check the box, can it get the serial number and the date and time and put it in an inactive sheet in the same workbook?

[ahmedalshamsi]

its super nice but in big data is glitchy and slow ? or it s just with me

[benjaminlkv]

the script works but there is no space between year and time. how to resolve this issue

[Readysetlian]

When I check the box, my date running one cell up and not beside the checkbox. How can I solve?

[bretthaggadone]

Why does the Date stamp always populate one cell to the right and one cell up from the check box I am checking?

[rananji]

The date is in US format, how to change it to UK format?

[tongabullbrothers]

After I close the sheet, it loses the macro

[killbillpandey]

Everything you explain is there in the previous video as you told then why did you make this video?🥶

[dvotviv]

i want to marry you!!! thanks for the perfect explanation