how do I number a form for repeated use?
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. |
All times are GMT +1. The time now is 11:51 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com