Here I link the checkbox 1 to cell C2 with entering =C2 into the Formula Bar after selecting the checkbox.įor ActiveX Control check box, please right click it and select Properties from the right-clicking menu.
To link the checkbox to a certain cell, please select it, then enter= cell reference into the Formula Bar and press the Enter key. You need to link the checkbox to a certain cell firstly, and then apply formula to achieve it.ġ. And blank the cell when unchecking the check box. Supposing you need cell A1 to be populated with value “test” when the check box 1 is checked.
Please follow the below methods step by step to deal with it.Ĭhange a specified cell value when checkbox is checked with formulaĬhange a specified cell value when checkbox is checked with VBA codeĬhange a specified cell color when checkbox is checked with VBA code For example, when a certain checkbox is checked, the value or background color of a specified cell will be changed automatically.
This article is talking about changing the value or color of a specified cell by a checkbox. How to change a specified cell value or color when checkbox is checked in Excel?
0 kommentar(er)
