Text box question
 

I have a userform which I have linked to a spreadsheet.

I need to know how to get the userform to clear textbox.1 once I hit the
enter key I have it working but it clear this textbox.

Also how do I get the userform to automatically refresh to show the updated
titles in the other textboxes on this form.

Thanks in advance

Greg