Adding text to a table via a macro or userform

Heres the scenario. I have created a table with the columns of name surname and gender. There are about 10 names, however i now what to create a button, which when pressed pops up a box (or something similar) which allows me to enter a name surname and gender and automatically creates a new row and enters this data. How can i proceed? (non excel expert so please give details in noob sentences)

Thanks

Originally Posted by jraj1106

Hi
You can try this too...

Attachment 153086

Regards..

Hi yea, thats exaclty what i need. How would i apply it to the 'Register' sheet on this spreadsheet?

Originally Posted by AlvaroSiza

What is the name of the worksheet on which you want the data to go?
By creates new row, do you mean, 1) places the data you have entered in the form into the next available (blank row), OR 2) literally insert a row within a populated range?

If No. 1 above, the answer to your question is to indicate the dynamic target range for each within the 'Submit' event of the form.

Say A1 is Name Label, B1 is Surname Label, and C1 is Gender Label.
Now assume you already have names, surnames, and genders spanning 5 rows down (through row 6).

Your form needs an "ok" or "submit" button, behind which lies the code indicating where the data is to go. In your case, It would look something like this:

Please Login or Register  to view this content.

Hi, Where would i paste this code? Also its number 2, i already have 10 names in cells so this new form would need to create a row and insert the name surname and gender

Originally Posted by jraj1106

Try this:

Attachment 153203

Regards..

Hey
Thank you, thats exaclty what i need. However how can i access the userform without having to press alt-F11. How can i create a button which will pop up this userform?