VBA code for adding data from a UserForm in to a spreadsheet

[Elvers]

Good morning. I have a basic User Form with 3 text box's. I want to click "Add Data" button to insert the data on to a spreadsheet. Below is what I wrote;

Please Login or Register  to view this content.

My spreadsheet has been saved as "DTMU Asset Log" and the line with the *********** is where I am getting an error.

Please advise if possible, thank you.

[davesexcel]

You have not said what the error is, I assume "Subscript out of range"?

Check the spelling of the sheet compared to the spelling in the code.

[Elvers]

Hi sorry, you are correct with the error message. But I have checked the spelling and they are the same.

[davesexcel]

There is some terminology confusion. Your original post indicates, "My spreadsheet has been saved as "DTMU Asset Log" "

Do you mean the Workbook is saved as that name?

[Elvers]

Yes the workbook has been saved with that name.

[davesexcel]

What's the sheet name?

If you are placing data into a different workbook,
You need the workbook name and the worksheet name

[Elvers]

Ok, so I am a complete novice....thank you for clearing that up for me! I have a question related to the code I posted, but will I need to make a new post?thank you again.