How to set control # in excel automatically?

[garacious]

Dear all,

I created a form in excel that has a control number.I want to create a formula that will automatically adds a series number everytime I will open the form.
e.g. I started at 001, then next time that I will open the form the series will be 002.

Is there a way to do it?please help.



Kind regards,
Garacious

[martindwilson]

increment a cell on close and use that value when you open perhaps
i dont know if you can hold a value in vba once you exit the sub.

[bejan]

If you don't want to modify the excel file you can use a txt (dat, tmp ...) file in your sistem temp folder (or in any folder you want) to read/write the #.