VBA code: link checkboxes to multiple cells at once Sub LinkChecks()Ĥ.
#EXCEL HOW TO MAKE CHECK BOXES LINKED TO CELL CODE#
Click Insert > Module, and paste the following code in the Module Window. Hold down the ALT + F11 keys to open the Microsoft Visual Basic for Applications window.ģ. Go to your worksheet with the list of checkboxes.Ģ.
If there are hundreds and thousands checkboxes need to be linked to other cells, the first method will not work effectively, to link them to multiple cells at once, you can apply the following VBA code. Repeated the above steps to link other checkboxes one by one. And then press Enter key on the keyboard, now, when you check this checkbox, the linked cell will display TRUE, if uncheck it, it will display FALSE, see screenshot:Ĥ. Then in the formula bar, type the equal sign =, and then click one cell that you want to link the checkbox to, B2 for example, see screenshot:ģ. After inserting the checkboxes in your worksheet, to select the checkbox, please press Ctrl key and then click the first checkbox that you want to link to other cell.Ģ. To link the checkbox to a specific cell, in fact, you can apply a simple formula to link them manually.ġ. Link checkboxes to multiple cells at once with VBA code Link checkboxes to multiple cells with formula one by one But, have you ever tried to link the checkboxes to multiple cells at once in a worksheet? Link the checkboxes to multiple relative cells may help you to quickly and easily do some calculations when you need to sum, count or average only the checked or unchecked cells. How to link checkboxes to multiple cells in Excel?
0 kommentar(er)
