Tailored button to write value on selected check box

[tranhaithang]

Dear all,
May I ask your help on this:
I have a loss tree file, which will be used to record why some weeks sale is lower than forecast. Users will need to click on some weeks, then click on the list of loss tree on the right side & click on button "Record". They need to record each & every week in the chart, and there will be different SKUs to be listed in this sheets.
What I'm trying to do is: a button that will find where the check box is ticked & which loss tree code is ticked, then write 1 to the range B31:AN46

I must confess I am a noob in VBA and don't know how to write this. Could anybody help me?

Thank you
Thang Tran