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

P

Patti

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.
 
C

CLR

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
 
Top