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: