Inputing data to Spreadsheet from Userform [Easy Question For Most] pls help me !

Hey everyone,

I am trying to get the VBA code to input data from my UserForm to last row of my spreadsheet for each column. A simple task yet I am struggling.

I have done my due diligence searching for answers here, on Youtube, on websites but have yet to find something that works, but as easy as this is the info I have found has proved useless so I am coming to you guys since you are a fabulous bunch and have helped me a lot in the past.

I have uploaded my Sample Spreadsheet, please refer to this if you are so kind to help me. I already built the UserForm, I just need help with the VBA code behind placing the data in the last row with data. It is really self-explanatory if you open up my Spreadsheet and see the user form. And if it can connect to that Button I put that would be all I need.

I have other pages where I will do similar UserForms, once I see how it is done by one of you I will learn from it and apply it to other sheets, it's just this part of getting off the ground I am struggling with.

Thanks Excelforum

kind of confused with those names in your code, GivenName, Tag Number, ***, what adjustments will I need to make

Originally Posted by lougs7

kind of confused with those names in your code, GivenName, Tag Number, ***, what adjustments will I need to make

The code posted by AlphaFrog should work as is.

Those names are the names you created for each textbox, combobox, etc in your userform.

Thank you it works. Sorry those random names that I was confused about came forma sample spreadsheet I downloaded so I didn't know wha thtey were.

But code works. You are fabolous thank you! Creds for you

Hey Alpha Frog, it works and all. But how do I connect the UserForm to a Button.

I would need a one line macro to call the UserForm, how would you do this in 2 secs. Asking you so I don't have to search for 20-30mins.

Appreciate it man!

got it :D :D :D you guys are awesome