Network forms - sequential numbering

[PP UK]

I'd be really grateful if anyone could tell me how to set up a counter so that everytime a new form is produced on a network it is assigned a sequential number. I've seen this on the built in spreadsheet solutions in excel and it looks really useful.

 

[royUK]

Hi

Check out this site for help on numbering
http://www.pexcel.com/download.htm

My Invoice Form hasthe number in cell B13 and the code I use to change it is

Range("B13").Value = 1 + Range("B13").Value

This is assigned to a button.

Hope this helps