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

Рет қаралды 37,440

Күн бұрын

Пікірлер: 48

@Excel10tutorial 9 ай бұрын

Recommend WPS Office-Best FREE alternative to Microsoft Office, Download for Win & Mac & Mobile. Free Download link: bit.ly/3vuZxOG

@RobertSpeed-o4e 9 ай бұрын

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

@Excel10tutorial 9 ай бұрын

Great. Please subscribe and share

@tonydiulio 3 ай бұрын

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

@nuc9ear 3 ай бұрын

With VarCheckBox.TopLeftCell.Offset(, -1)

@Excel10tutorial 2 ай бұрын

You need to change the code a bit. Find the below line in the code: With VarCheckBox.TopLeftCell.Offset(, 1) Now replace the above line with below line: With VarCheckBox.TopLeftCell.Offset(1, 0)

@petermarcussen6265 9 ай бұрын

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

@miaaTOOfine17 11 ай бұрын

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

@Excel10tutorial 11 ай бұрын

link is in the video description.

@lalu15248 10 ай бұрын

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?

@Excel10tutorial 10 ай бұрын

Yes. Its possible. Change the vba code where you have the column name to you'r preferred reference.

@ahmedalshamsi6644 Жыл бұрын

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

@CW-cj6nd Жыл бұрын

likely because of the ".EntireColumn.AutoFit" line which just make the column wide enough to fit text. You can remove this and resize the columns manually and it should run quicker.

@mikeyb4642 Жыл бұрын

Mine isn't that large (600 rows with 5-6 columns per row) and it starts off quick, then slows down quickly until closed and reopened.

@AmandeepSingh-yi5xr Жыл бұрын

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

@FamilyBenjamin 4 ай бұрын

I love this! Thank you!

@Excel10tutorial 4 ай бұрын

Glad you like it!

@bretthaggadone4497 Жыл бұрын

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

@xusiekerlly6648 Жыл бұрын

the same problem :(

@xusiekerlly6648 Жыл бұрын

and I've just found out how to fix it also (: in line 4 of his given code, you add one more number "1" after the parentheses and before the comma. It looks like this With VarCheckBox.TopLeftCell.Offset(1, 1) maybe he forgot this little "1" (:

@marianolasco251 Жыл бұрын

@@xusiekerlly6648 I added the 1 after the parentheses and before the comma. That was able to adjust all the other date stamps except for the very first one, now it populates one cell to right and one cell down from the checkbox. 🥲

@atiqahbee 11 ай бұрын

@@xusiekerlly6648 Try this With VarCheckBox.TopLeftCell.Offset(1, 1)

@jonny396099 6 ай бұрын

@@xusiekerlly6648 Verify the size of your object fits entirely in the available row height. If there is any overlap, it may cause the time stamp to be offset. You can fix it by changing the vertical offset as you have described or you can move your object. Make sure the bounding boxes are small enough to fit in the row as the size of a checkbox does not actually change.

@rajeevakumardubey4602 Жыл бұрын

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

@benjaminlkv3594 6 ай бұрын

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

@Excel10tutorial 6 ай бұрын

Increase space here .Value = Date & " " & Time like this .Value = Date & " " & Time

@artloverrarts Жыл бұрын

just what i needed tyy

@Excel10tutorial Жыл бұрын

Great. Please subscribe.

@rananji Жыл бұрын

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

@Excel10tutorial Жыл бұрын

Change the date from your computer

@Readysetlian9 Жыл бұрын

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

@abbiemcevoy4163 6 ай бұрын

same did you solve this?

@jonny396099 6 ай бұрын

@@abbiemcevoy4163 Verify the size of your object fits entirely in the available row height. If there is any overlap, it may cause the time stamp to be offset.