Shortcut To Link All Check Boxes To Cells With A Macro In Excel || Excel Tricks

[@Ejmillanv]

I had this massive checklist and I was afraid I had to assign every single box manually, this video literally saved me A HELL OF A LOT OF TIME and my sanity

[@yogeshkhandagale7664]

No drama, and no too ,much of talking. Simple and very clear explanation. Thanks a lot. Please keep it up.

[@dptutorials]

So nice of you

[@OmarElsayadx]

This video saved me HOURS and HOURS of extreme work I would have done on a very long excel sheet. you're a life saver

[@dptutorials]

Most welcome

[@genes7154]

This probably saved me at least a good hour of work and boredom. Linked 160 checkboxes all at once. Still have at least 160 more to go. Created the module, copied and pasted the macro into the module, and ran it. Worked perfectly without a hitch! Thank you! 😄

[@Darthpeegs1039]

Amazing. Seriously, this video genuinely saved me hours upon hours of manual labor on a very long worksheet. Appreciate the time you took to make this, thank you so much!!!

[@Mynameisrex72]

You are a GENIUS !!!!!!!!!!!!!!!!!!!! Thanks for your help - I saved hours and hours of boring work

[@dptutorials]

Glad I could help. It's motivating for me too

[@jasonp220]

Thank you! Works perfectly even over a large grid of check boxes.

[@Hugeworship]

Thank you brother by this I do good performance in excel sheet

[@ahmedabdulkadir6298]

Thank you, this was helpful

[@neoappiah6196]

Thank you very much Boss

[@harmenvanheist7348]

Finally one that works, you're a hero.

[@DanielGabani]

Great video! Thank you very much! Gonna speed up my task by 10x at minimum :D

[@radomircvijetic3334]

Thanks a lot, works perfectly!!!!

[@dptutorials]

You're welcome!

[@FuzzyWuzzaBer]

Very informative video! Thank you! Just a question. What if I wanted to COUNT the checked boxes and have the sum value represented in a given cell as I check them?

[@user-dz9eb7fu2f]

this was a lifesaver omfg thank you so much

[@dptutorials]

Most welcome, please subscribe for more videos.

[@IndraEighty-Six]

Thank you so much!!! You’re a lifesaver 🙏🏾

[@foxynight1688]

If I have 1000+ row records of checkboxes, will changing one checkbox's status to true or false cause all the other checkboxes to change as well? If so it would cause the file to run the loop every time one checkbox is checked or unchecked

[@dptutorials]

That's a great question! I'll make a video about that.

[@syaaackzint]

The function of TopLeftCell, can we change to the cell that the checkbox placed?

[@aponijuanzosimo9923]

Hi @dptutorials, is this possible to add scrollbar? coz I want to add scrollbar so that the data will not looks like huge upon viewing.

[@brutalbliss]

Thank you for this!

[@dptutorials]

Most welcome

[@rajeevgosavi4514]

Thanks for your simple to understand VBA code. However when I applied this macro to my office sheet , even the heading " Done" is also changing from true to false , as I have applied this macro in zero column i.e . same as checkboxes

[@maxkaiser5438]

Thank you so much! Helped me perfectly :)

[@dptutorials]

Welcome. Please subscribe and raise questions if you have any.

[@JoelMendoza-sq1kk]

I would like to ask, does this function if I want multiple columns of check boxes and each one references the cell its on top of?

[@ghostcon]

Nothing is popping up under my macro. All of my cells show true after adjusting the lcol = to "0". Any idea why it wouldnt be showing up in the Macros drop down?

[@ramram5815]

thanks you so much for sharing this trick

[@dptutorials]

You are so welcome!

[@rafaeldeconde8148]

Thank you very much!! Ths video is extremely helpful!!!

[@dptutorials]

Glad it was helpful!

[@shamsshams9762]

Thank you so much 😀

[@dptutorials]

You're welcome 😊

[@irjacq27]

What is the macro if I want to link the checkbox in column F6 onwards?

[@abdulhamidhilwany]

thank you so much you save my time

[@rowelmagbanua9634]

It really helps a lot. What if I have multiple checkbox in each column? How can I add it in VBA code command? is it lcol = 3,4,5 and so on? Thanks for response.

[@fajarmahendra7732]

GG excel Mr 😊

[@MountainDewBots]

This tutorial was an absolute savior, I searched for hours for someone to explain an easier method to effecting a large quantity of check boxes without having to manually change each linked cell (working with 200 check boxes) The only issue I ran into was the original check box liked to change the linked cell 1 up and 1 over. Not only that but now for whatever reason if a single check box is selected it updates ALL the check boxes, so if I am using these boxes for the sake of taking time stamps it can completely and quickly destroy the intended data its meant to capture. Could it be that I am attempting to stretch this over too many check boxes and that is what is causing this error?

[@saravanajis4080]

Ou87

[@JacopoSavelli]

can I also drag the checkboxes cells to the right or left, run the macro, and expect to have the linkedcell with true and falls on columns J or L?

[@technicalknowledge9128]

Suppose I have 3 check box I want to one check box click and automatically 2 check box select how to connect vba code

[@victoralvarado3291]

So how would I link it to a cell that is to the left of the checkbox?

[@eigj999]

Great! Thank u very much!

[@MamoonaMohsin]

life saver , thanks allot

[@dptutorials]

You're welcome!

[@CuteMyđángyêu]

wonderful, thanks so much!

[@martinofficial2707]

How to change the checkbox linked value as YES/NO.

[@mrmarnissi]

Very Helpful big thanks you are genius

[@85MA]

I have a worksheet with the following data,,, vendors name in Column A2 , Paymnt Amount in Column B2. Check-boxes in Column C2, Paid/Unpaid text in Column D2. I would like to establish a link between check-boxes and the 'amount' column. Specifically, I want the checkbox in column C2 to be automatically checked when I enter an amount in cell B2. Additionally, when the checkbox is automatically marked as checked, I would like the text 'Paid' to appear in column D2. Is it possible to achieve this using a formula or VBA/Macro?

[@simpleshortpractice]

helpfull, thank you love love

[@dptutorials]

Most welcome

[@markernc]

When I tried this it was selecting the cell right above the one I was trying to link...where did I go wrong? Thank you!

[@actuallyjess1107]

I'm having this same issue!

[@caseym8177]

I had this same issue. The table I was working with had column headers so I deleted them and had my data starting from row 1. Running the macro from there linked the checkboxes correctly. There's probably a better way to fix this but this worked for me

[@Marcvids41]

You need to change the "0" to 1(or were your row starts) before ICol. Sub LinkCheckBoxes() Dim chk As CheckBox Dim lCol As Long lCol = 3 'number of columns to the right of checkbox For Each chk In ActiveSheet.CheckBoxes With chk .LinkedCell = _ .TopLeftCell.Offset(1, lCol).Address End With Next chk End Sub

[@palermo017]

@@Marcvids41 thabks a lot bro!!!!!!

[@Kostka74]

The best!

[@KrishnaAgarwal-vt2lh]

Similarly can you show how to unlink all check boxes

[@m.umairanwar3346]

Code giving error while running at lcol=3 Saying "can't execute code in break mode" Need little guidance

[@JacopoSavelli]

is there a way to check or uncheck all checkboxes at once?

[@threciabarazan2998]

Thank you 😊

[@dptutorials]

Most welcome

[@dilukshanuka1333]

what's the code for linked to same cell? Thanks

[@George-wb2qf]

just use lcol=0 instead of 3

[@thaisaguiar9445]

Thank you :)

[@maheshk7133]

sir when I click on check box , false and true will appear on the upper cell , it has to be linked with same row

[@Ejmillanv]

I had the same problem but turns out it's very easy to figure out, you know the line with "(0, lcol)" well 0 is basically the A1 cell and my checkboxes started in the A2 SO what I did what replace the 0 with a 1 and now everything is lined up, I know this is 7 months late but probably someone else had the same question

[@charliek9394]

IF you want to do this for activeX checkmarks in a single column and have them linked to cells in another sheet, is that possible?

[@hannablom5803]

I wonder that too!

[@Planemech]

I ran the Macro and it didn't line up with the checkbox, it was up one cell. I tried several times and got the same result

[@BlakeBiellier]

​ @broland80917 You need to make sure your first checkbox border (The one that is to resize with the name) does not overlap into other cells. Also, You need to make sure no duplicate boxes are hidden behind the first check box you create before copying them to other cells. Plus, make sure none are currently linked before running the macro.

[@Kariboo925]

you are smarter than chatgpt !

[@dptutorials]

Haha, this is too much

[@layalkazouh1817]

At 2:52 I was lost

[@abdulhamidhilwany]

i hope you are fine

[@MichaelKuo-y3p]

doesn't work.

[@armandoanley4740]

No help at all. I'm not a VB user, I work this deep with excel quite occasionally, there should be an easier way to do it without using VB. Sad Microsoft doesn't come up with it.

[@BlakeBiellier]

Unfortunately, there is no other other way. Other then a few other different macro codes that essentially do the same thing. Just written slightly different.

[@PiliPala99]

Half of it is great, but you don't explain the references enough to make it useful on another spreadsheet. At least not simple enough tjhat I can understand. The TopLeft.Offset etc... if you explained why you did that I could figure out how to make it work on my sheet. Excel is so dam infuriating!

[@dptutorials]

Noted

[@carajatagrawal]

Error 438, when i click debug, "[.LinkedCell=_ .TopLeftCell.Offset(0,lcol).Adress]" is highlighted. Please Help

[@david_pgd]

I had the same error, see if your problem is that you had written .LinkCell = _ instead of .LinkedCell = _

[@carajatagrawal]

@@david_pgd my problem was solved when I adjusted 0 according to the starting column number.

[@RoRo7051.]

@@carajatagrawal I still couldn't get it to work. Sam error 438. Ugh

[@carajatagrawal]

@@RoRo7051. try chatgpt. It gave me the exact code.

[@BlakeBiellier]

​@@RoRo7051. You need to make sure your first checkbox border (The one that is to resize with the name) does not overlap into other cells. Also, You need to make sure no duplicate boxes are hidden behind the first check box you create before copying them to other cells. Plus, make sure none are currently linked before running the macro.