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

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
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
 
Back
Top