Auto sequential number generator

[petersmith5]

Hello there

I am trying to create a form where one of the cells contains a unique number/referrence to identify the form. Is there something I can do that allows me to open the form and it automatically assign a number (next sequential makes sense to me) and then saves allowing others who have access to the shared folder and form to open the form and use it without the risk of duplicating the referrence?

I suspect more complicated that I have expressed above but all help appreciated.

Rgs

Peter

 

[Andrew Poulsom]

This may help you (use a template):

http://www.mrexcel.com/forum/excel-questions/33673-auto-numbering-cell.html

 

[petersmith5]

Thanks for this; the code works, does exactly what I want it to but unfortunately not on my laptop or my colleagues (but I have checked it on one not configured by my employer). I will ask my IT people to look into the settings as I have done everything obvious in the settings to make it work but so far without any luck.

I will come back to you once I have done a little further investigation...