You can put a counter in a hidden cell of worksheet.

In the Workbook_BeforeSave you can:
  1. reduce the counter with 1 until you hit 0
  2. Set new value for textbox1
  3. Set new value for textbox2

During opening the workbook (Workbook_open ?) you can set the value you want for the text boxes...