How do I get a unique number on a form when I open it each time?
 

I want to create a form/template that an end user can open each time and have
a unique number appear in a field. Would like the number to be incremental,
if possible.

How do I get a unique number on a form when I open it each time?
 

Maybe something like this........

Private Sub Workbook_Open()
Dim username
username = ActiveWorkbook.BuiltinDocumentProperties.Item("aut hor")
Range("a1").Value = username & "-" & Date & "-" & Time
End Sub


Vaya con Dios,
Chuck, CABGx3


"Patti" wrote:

I want to create a form/template that an end user can open each time and have
a unique number appear in a field. Would like the number to be incremental,
if possible.

How do I get a unique number on a form when I open it each time?
 

Patti

You will need to employ a little VBA.

See John McGimpsey's site for code.

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


Gord Dibben MS Excel MVP


On Fri, 8 Jun 2007 10:27:00 -0700, Patti
wrote:

I want to create a form/template that an end user can open each time and have
a unique number appear in a field. Would like the number to be incremental,
if possible.