Display last record in Userform

Dear Sir,

My sheet("Table") has three fields as

code--------item---------price-----
1-----------book---------50-------
2-----------copy---------75-------
3----------Pencil---------95-------

my Userform has three textboxes as txtcode,txtitem,txtprice
How to display the last row in textboxes.

When Userform loads all three textbox must flled as
txtcode=3
txtitem=Pencil
txtprice=95

Plesae help

Try something like the following :

Please Login or Register  to view this content.

This should give you a starting point anyway

Let me know how you go!