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

[Guest]

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.

 

[Guest]

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

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


Vaya con Dios,
Chuck, CABGx3

 

[Gord Dibben]

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