How to Entry Data to Chosen Active Cell from User Form

Hello, please help me because i am still very new to VBA and Macros.

Is it possible that we can select the Active Cell to be our starting cell (idk if that's even a word) everytime we want to entry data by Userform?
In the file I attached below, I have a Multiple Page Userform (Userform 2 in VBA). The pages have identical five text boxes and some command buttons. What I want to do is that every time I entry data from the first page of the Multiple Page Userform, it will be written on column N-P, R, and S but in any choosen row that i want. the same goes with page 2 but to column T-V, X, and Y.

I imagine I can click on the specific cell to be the starting cell first, and then run the userform, and when i click save it will be recorded like what i just explained above. but i don't know if it's possible or not.

I am sorry I only can provide you with the code and some pictures of the worksheet and userform because my file is too large.
Your help will be greatly appreciated because i need this to make my 9-5 job a lot easier.

Thank you.

Assuming the "starting cell" is on row 10, you want the first record to save to row 10 then the next one to 11 and the next to 12 etc?
Or would you close the form each time and select a new row then save the data to that one?

If the first scenario above is correct then try the code below:

Please Login or Register  to view this content.

BSB