如何调整此数据输入表单

I have a userform with one text field and one submit button on it. I want the user to be able to enter a name in the text field and click the submit button and have the name entered into the spreadsheet. After clicking submit I would like the last name to disappear and leave the cursor in the text field so the person can continue with entering another name.I have a userform with one text field and one s