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
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)
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.
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?
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" (:
@@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. 🥲
@@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.
@@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.
Recommend WPS Office-Best FREE alternative to Microsoft Office, Download for Win & Mac & Mobile.
Free Download link: bit.ly/3vuZxOG
You sir, just solved a massive issue I was having not being able to use Google Sheets. !!!!!!!!!!!!!!!!!!!!
Great. Please subscribe and share
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
With VarCheckBox.TopLeftCell.Offset(, -1)
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)
Great video, is there a way to auto add account name in a cell aswell?
How do you add the marco time stamp tho? How did you create it?
link is in the video description.
I love this! Thank you!
Glad you like it!
its super nice but in big data is glitchy and slow ? or it s just with me
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.
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.
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?
Yes. Its possible. Change the vba code where you have the column name to you'r preferred reference.
Thanks you
Most Welcome. Please subscribe and share
just what i needed tyy
Great. Please subscribe.
Why does the Date stamp always populate one cell to the right and one cell up from the check box I am checking?
the same problem :(
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" (:
@@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. 🥲
@@xusiekerlly6648 Try this With VarCheckBox.TopLeftCell.Offset(1, 1)
@@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.
thanks Man
Happy to help. Please subscribe and be with us.
Sir while i apply filter in check box excel sheet .check boxes are overlaped.
Dear I’m unable to fix how to lock columns on dates , I watch your video but not resolved the issue
the script works but there is no space between year and time. how to resolve this issue
Increase space here .Value = Date & " " & Time like this .Value = Date & " " & Time
When I check the box, my date running one cell up and not beside the checkbox. How can I solve?
same did you solve this?
@@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.
After I close the sheet, it loses the macro
Save the workbook in .xlsm format.
The date is in US format, how to change it to UK format?
Change the date from your computer
cannot set the module line 3
Code is linked in the video description.
@@Excel10tutorial Still cannot working
@@Excel10tutorial i m already copy/paste that code
Everything you explain is there in the previous video as you told then why did you make this video?🥶
Because this video is the combination of two different videos. Timestamp and Checkboxes.
i want to marry you!!! thanks for the perfect explanation
So nice of you