UserForm in a For To loop

[j_Southern]

Dear members
I have a partialy filled table that is to be completed using TextBoxes on a userform
I use a For To loop to identify an uncompleted row by looking for the value 0 in a specific column and then fill in the texboxes with the known data and wait for the user to fill in the TextBoxes for the uncompleted data.
This manualy filled data is then to be transfered to the table. The next uncompleted row is identified and the process is repeated till all is done.

The code in the attached workbook does not work. It runs through all the rows stopping at the last row which is the only one that can be completed. I need somehow to stop the loop from happening until after I have completed a record.
Can any one help please
The button "Complete" on Sheet1 is the one that activates the form.
John