Display username in a cell adjacent to one that has been edited

[Jimbs4]

Hi all,

just trying display the username of the person who edited a cell. So say B2 was blank and 'ABC' was input into it, when this happens C2 is populated with the username of the person who has done it and D2 has the date and time. Thanks in advance

[MarvinP]

Hi Jim,

Something like this?

Please Login or Register  to view this content.

This code needs to go in the module behind a sheet.

[Jimbs4]

Thanks Marvin, sorry not familiar with what you're say 'module behind a sheet'? I'm obviously not doing it right as the macro does not appear

[Jimbs4]

Ok, wow, I got it, not in a module but in a sheet! that's amazing I didn't realise you could do that and run something without physically running the macro. Thanks Marvin.

Just wondering, can I also change that to a range of cells? Such as if B2:B100 usernames will appear in cells C2:C100?