I am writing a code that will upload information collected by the user using a Form. There are 6 columns that will each have a row of user information which I am collecting using the form. I want to upload that criteria using a Do Loop to work my way down the rows. The form features a button to Add their info to the row. My problem is I want to use a Do Until loop and my until will be = whatever the code is when the user clicks the red x box. I am not sure what that value is.

Thanks in advance