Question: how to check checkbox value in vba?
Answer: On the Developer tab, click Insert. In the ActiveX Controls group, click Check Box. Drag a check box on your worksheet. Right click the check box (make sure Design Mode is selected). Click View Code. ...  Add the following code lines: