Making a Unique ID

[whcmelvin]

I am wondering how to make a unique ID to allow new ID to be generated and it must be unique. i tried using the combination of date and time but I realise there can be the same if 2 users are using the excel.

 

[Jaafar Tribak]

Take a look here

 

[texasalynn]

you could use their network log in like this

Sub UserID()
Dim UserID As String

UserID = Environ("USERNAME")
MsgBox "The UserID = " & UserID
End Sub

 

[whcmelvin]

Thanks for helping me out.