Autofill Cell with Author

[scooby56]

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.

 

[scooby56]

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.