Add Username Cell Reference to existing VBA

[jedemeyer1]

Good Day All,

I need help with a current problem. I have a workbook sheet where I used a USERNAME() formula (Not in VBA) on a locked cell.

Problem is that every time a user opens the sheet, it takes that users id and fills all respective cells with its id.

I would like it to keep all username id's as it was entered by that user.

With some searching I think I should try a VBA approach.

However, I cannot for the life of me insert it into my existing sheet change.

Please see below, target cells is correct. I need it to put a "current" username reference in column C, and a Date reference in Column E.

Please Login or Register  to view this content.

Please this is very important as I have to implement this sheet by end of this day.

Thank You

[patel45]

to get username you can try the followin codes

Please Login or Register  to view this content.