Autofill Cell with Author

S

scooby56

Joined
Sep 5, 2005
Messages
3
Reaction score
0
Hi, first time posting...

Im creating a table for multiple users. when they tab or click into the 'Entered by' Column i want to capture the Author information into a vairiable. I've managed to do this with a 'Todays Date' column but can't find any help to return the authour of the document.

Also if I use a Form to enter new records is it possible to auto fillthese feilds? if so any suggestions on the vb code.

Im failry new with excel but have experience with VB.
 
hi,
managed to sort it. in case anyone else is wondering you can get username of the user logged in with

Dim Auth as string
Auth = Application.Username

Thanks.
 
Back
Top