Hi all,

I don't know if this will make sense, but here goes. I currently have a userform, which has submits to a spreadsheet via a command button. Basically I am doing data entry and then submitting it - I tend to submit several data inputs at the same time. I have a textbox on the userform with the number 1 in it.

What I would like to do is that each time you press the submit button, it adds an additional 1 to the textbox mentioned above, so when you go to submit your next one it will say 2 and then when you submit again it will say 3. This will keep going everytime I submit until I close the userform down and have finished adding to the spreadsheet for that round of data entry. At which point when I open the userform up again, the textbox will revert back to having a the number 1 in it.

I hope this makes sense. Any help would be appreciated. I've tried googiling it and working it out myself without sucess.

Thanks all.