How to submit data from Userform to sheet

[SteynfaardtD]

Hi Experts

Please assist me in this.
I am new to macros and try to learn everything form the internet, but don't always know what to search for.

I have created an Userform and now I am struggling to get the data from Form to Sheet.

This is the code I am trying to use, Note that it does add the data form the form to the sheet but gives me an error after every attempt.
Error on submit Data.JPG

My Code

Please Login or Register  to view this content.

Please note that i will still add an If function due to my form having to report to 3 different sheets.

Thanks

[davesexcel]

Do you have 37 textboxes?
Find out what value i is when the code errors

[SteynfaardtD]

it does not say, Yes i have 37 text boxes.

Will it be because not all textboxes contains data?

[SteynfaardtD]

it does not say, Yes i have 37 text boxes.

Will it be because not all textboxes contains data?

I tested it with

Please Login or Register  to view this content.

And this works,

I need to have it do the copy even if the textboxes are blank. Because not all data will be submitted everytime

[davesexcel]

It does say....

Hover over i when the code errors. You will see it's value is 34 you don't have a txt34 you also don't have a txt36

[SteynfaardtD]

is there a way that i can see a list of command that i have inserted to my user form,

Sorry for the irritation, Know it is frustrating to explain **** to people. But i really do appreciate the effort

[davesexcel]

In the UserForm module, you can click the dropdown.
-

userformVBAMo.jpg

[SteynfaardtD]

noted Thanks, I saw on internet that there is way to list the commands of the userform.?

Please assist in this,

Please Login or Register  to view this content.

Gives me

Else without if

Error

[SteynfaardtD]

In the UserForm module, you can click the dropdown.
-

Attachment 611678

Was looking for tab order, But managed that one thanks

[davesexcel]

You need to close all the "If " Statements
You also need to close all the "With" statements

If you start a "With" statement inside an "If" statement, you need to close it Before you close the "If" statement.

[SteynfaardtD]

tried that, still gives me same error

[davesexcel]

What did you try

[SteynfaardtD]

What did you try

Please Login or Register  to view this content.

[davesexcel]

did you read the last line of Post#10?

[SteynfaardtD]

did you read the last line of Post#10?

Please Login or Register  to view this content.

The MsgBox gives me error

[davesexcel]

You have a space between the quotes and you have an extra "End With"