Re: auto gererated number when sheet opened

[Manq5230]

Re: auto gererated number when sheet opened

I have a form that I wish to make into a template for our customers to fill in. I would like to have the "Purchase Order" field I've created to have a number automatically fill in with a new number everytime they open the template. Then they would do a save as and that number would stay with the saved file. Then when they open the template again it would then generate the next number in succession. Can this be done.

Thanks
Anthony

 

[franseen]

Re: auto gererated number when sheet opened

ok i have fixed the second problem, getting it to display 00001 etc, simple formatting issue. But still not having any luck with the first part. The auto implementation of the script.

 

[Andrew Poulsom]

Re: auto gererated number when sheet opened

You need to put the code in the ThisWorkbook module, not in a general module like Module1.