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.