How can I submit a VBA form to enter the info into an excel sheet? -

i'm pretty new vba , trying use vba form in excel. user can enter information , press button submit information excel sheet corresponding headers. have form i'm having troubles submitting it. i've tried using this

private sub commandbutton1_click()    'copy input values sheet.    dim row6 long    dim ws worksheet    set ws = worksheets()    row6 = ws.cells(rows.count, 6).end(x1up).offset(1, 0).row    ws     .cells(row6, 1).value = me.itemnumber.value     .cells(row6, 2).value = me.itemdescription.value    end 'clear input controls reuse. me.itemnumber.value = "" me.itemdescription.value = ""  end sub 

,but keep getting type mismatch error (error 13). how fix or there other methods have same effect. please , thank you.