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.