A couple of more questions: If the sequence numbers are permanent, they need to be part of the record. Do the numbers have to be contiguous among the entire set of reecords or can you have gaps? (If you had a selective display and permanent numbers for each record, there would be gaps anyway.)
Are you familiar with the "autonumber" concept? If not, read up on that online (including many articles in this forum). If that will do what you want, VBA never enters the picture. However, autonumbers can have gaps so if the number MUST be contiguous, another solution will be required.
The reason I'm asking these questions is because the required properties of your number are clearly the crux of your question but they are not clearly enough described for us to know how best to answer.