user forms to add data to columns

It has been a while since using Excel so I am quite rusty and I am struggling with user forms. I have a workbook with 2 sheets which each need a form for someone to interface with to add records. I know how to build the forms I just can't figure out the VBA coding to get them fuctional. I was hoping someone could give my example a look and give a hand. I am currently using Excel 2007.

Any help would be greatly appreciated.