Sr. No. to be displayed automatically

I am designing a userform where I need to put a Sr. No. Everytime the form is called, it should give a sr. no. but until & unless the data is submitted, the number should not change. I mean to say that if the sr. no. is 1 and I close the form without submitting, when i recall it again it should show sr. no. 1 only.
Also I have multiline textbox that I am using and the data is pasted in the same column but one below the other in different cells. So the sr. no. should not be displayed on every row. It should only be pasted in the first cell only.

Can you post a sample workbook so we can better help you

Please find the image showing how i need the data.
Data from Q cell onwards is a multiline data saved individually in each cells.
srno.jpg