Adding Checkbox functionality to working Userform

I'm looking for some help with adding Checkbox functionality to a current userform. (also tabbed pages, but that's secondary)

The userform (attached as "WorkingExample") is a stripped down version of a much larger one I'm currently using for Data Review, and Input. Much of the help in design and refinement came from the experts and moderators of this forum.. (I thank you all again, and again).

I am having difficulty with what seem like they should be very simple tasks. (clearly not so simple for me.. I am still very new to this and learning)

1. I would like to be able to have a Checkbox that if selected (checked = True) inputs a "YES" into the cell associated. If left unselected or later deselected (Checked = False) then leave the cell blank.

Seems like it should be simple, but I haven't been able to get it yet.

2. I would like to be able to utilize Frames, and Tabs on the userform, but everytime I try to use either all I get are errors.

I have included the working example, so you can see what is there and how it functions (very happy with it currently).

Also included a second showing a version with a checkbox, a tabbed field with a textbox on tab 1 and another on tab 2, as well as a textbox in a frame. All of which have columns on the Wks labeled to associate with them.

Both are in Excel 2007 (when I tried to save in 97-03 for some reason it added 2000k to the file size. If you need it in 97-03 I will try to figure out what is causing the bloat.. suggestions welcome)

I've tried too many different things to explain, and didn't want to include those attempts as most would likely just confuse.

If someone is willing to get the checkbox functioning as requested, please add notes as to what you did and where (in the code is fine)

Same goes for the Tabs, and Frame.

Thanks again to all for your help, patience, and kindness.