Hi

You would have to save the last entered data in an excel database or just
some cells on a worksheet or some hidden labels on the userform when you
close the userform and then read it back into the textboxes when the form is
inialized.

HTH

Ken