add data to table from userform

[Undo]

Hello

I have Table and userform
I need vba code that once userform load, select last row in the table and insert new row( insert not expand ), then select the first top blank cell in column B
then inert the new data from userform to same selected row

Thanks

[torachan]

your form with code added.
note:- do not manually extend form - this takes place dynamically with tables

[Undo]

Thanks for help
I appreciate ur edit, but I want the steps exactly like I mention, because I will continue coding
only exact steps will help me to go ahead
Thanks

[torachan]

you are defeating the purpose of tables by filling in one column and then finding blank in second column.
you may as well just use a range - as i can see no purpose to your method i will let someone else respond to your request.