vlookup in vba

I am struggling to see where I am going wrong and now pulling my hair out. Why does this not work? I have a userform with 2 txtboxes. I want txtbox2 (namedtxtOrg) to display results from value entered in txtbox1 (NamedtxtVPD). In txtVPD I code on exit: txtOrg value=application.worksheetfunction.vlookup (txtVPD,sheet2(A1,[C1100]),2,False).

I have tried many variants of this and got many errors. I am doing something wrong. Please, please any ideas would be grand.