Excel/VBA Assistance needed!!

I have created a spreadsheet and a few user forms in Excel/VBA. Having a hard time linking the userform to the spreadsheet. I can open thru a commandbox on the sheet to enter a new item, tab thru/enter the information, but the add item button will not connect, the cancel/exit however, does. Also help with the second button that I cannot find how to search by cell. thanks!!