On your userform, you would place this code in example: TextBox1_AfterUpdate()

Then this time will submit to your worksheet like you are doing now. If you can, post a copy ** your workbook (take out any personal info).