Time and date stamp

[nuno]

Hi


I am loooking for either a forumla or some vba that will enable me to log when a cell is popoluated.

Column Q is where the data is populated and what i need is someway to put the excel User Name, time and date into the next cell in column R

Q R

yes testusername - 24092007-1515

Does that make sense?

Cheers

Nuno

[VBA Noob]

This link may get you started

http://www.mcgimpsey.com/excel/timestamp.html

this will return the excel user name

Please Login or Register  to view this content.

if you need windows user name then take a look at this link

http://www.exceltip.com/st/Function_...Excel/452.html


VBA Noob

[nuno]

I have figured it out...

Please Login or Register  to view this content.

[VBA Noob]

Good to see

VBA Noob

[DCSwearingen]

[QUOTE=nuno]I have figured it out...

Please Login or Register  to view this content.

Many companies set up a standard image with the company name as the standard Office UserName (Application.UserName). If that is the case for your company, that will be the username inserted.

Changing

Please Login or Register  to view this content.

will use the individual login name.
Changed code

Please Login or Register  to view this content.

I know Environ("username") works in Windows NT and XL using Office 2000 or Office 2003 without having to do any API calls.

As for the date & time stamp, the following code will give a variable in the form of YYMMDD - hhmm. I usually make the date & time stamp format this way for sorting purposes. Just rearrange the order to give the format you desire. I am sure this can be made more efficient, but it has worked for me for several years...

Please Login or Register  to view this content.