I am trying to create a template form that will number the form
automatically. I will be using this for to invoice from and want it to
number each one so a number can't be skipped or used twice. What can I do.
The only thing I have done is used a spinner button, but this has to be
changed each time on the form and doesn't relate back to the template.

Nicole

Check out JE mcGimpsey's site for VBA methods to produce sequential invoice
numbers.

http://www.mcgimpsey.com/excel/udfs/sequentialnums.html


Gord Dibben Excel MVP

On Wed, 18 May 2005 11:31:05 -0700, "Nicole-A"
wrote:

I am trying to create a template form that will number the form
automatically. I will be using this for to invoice from and want it to
number each one so a number can't be skipped or used twice. What can I do.
The only thing I have done is used a spinner button, but this has to be
changed each time on the form and doesn't relate back to the template.