excel - Multipage Lookups - Update and Save -

i have search function opens user form (frmrecorddetails) id (txtfnumber) referenced @ top, contains multipage userforms.

now want is, when opens up, lookup , fill textboxes relating thefnumber. reference spreadsheet static not grow or contract , unique id in column a. want fill each corresponding text-box, in each multipage tab row has unique id.

also when user has updated want able overwrite record sheet.

tried few bkookup on initialize tutorials/ functions nothing happens. no error messages. know general way reference userform text box on multipage search sheet, column return corresponding values.

also return them. im pretty green vba/userform stuff