Hello there,
Try the following code:
to insert the code:
1. Open Visual Basic
2. Select your userform and then right click on the submit command button and select view code.
3. In between the Private Sub NameofYourcommandbutton_Click() and End Sub copy and paste the above code.
4. Anything that appears in green is a comment meant to help you understand. You'll need to read through it so that you can adust the code to fit your needs.
5. Close out of Visual Basic.
Let me know if this works for you!
Thanks!
Bookmarks