00:00want to see the most cringiest thing ever in excel i'm talking about working with checkboxes
00:05hear me out now let's say if you have a checkbox and when people check here you want to see
00:08the
00:08status of true and false here this idea right click on this checkbox format control and on
00:14the cell link you can select the cell that you want to affiliate it and hit enter twice and now
00:18if you put a check next to it or remove it you can see if true and false status here
00:22now do the same
00:23thing for the rest of the rows you say why don't you just ctrl c and ctrl v to the
00:28rest of the rows
00:28and that should solve the problem isn't it no not really you're gonna have to right click and do the
00:33same thing for every checkbox in your worksheet well that's a much easier way out of this madness
00:38right click on the sheet name view code paste this bba script if you need a copy of this bba
00:43script
00:43please leave a request on the comment section i'll send it to you ctrl s to save and hit play
00:47now you can go back to your worksheet now every individual checkbox is uniquely linked to the cell
00:52adjacent to it
Comments