tsroque
Board Regular
- Joined
- Jan 19, 2007
- Messages
- 126
- Office Version
- 365
I saw a code for this, but it's document specific. If I have to do this in a VBA code, I'm fine with that.
I need to automatically capture the date/time and system user name if anything is a row is changed. So if I change anything in Row 2, the date/time is displayed in A2 and User Name is displayed in B2. If I change anything in Row 3, the date/time is displayed in A3 and User Name is displayed in B3, etc...
I would also like the words "UPDATED" in column C if a change happens in that Row and for the changed cells to be highlighted in YELLOW until the words "APPROVED" appear in that cell (will be from a validation list user can select from).
For the color, user can manually overwrite it just in case they put focus on it and then decide not to change anything.
Thank you!!!
I need to automatically capture the date/time and system user name if anything is a row is changed. So if I change anything in Row 2, the date/time is displayed in A2 and User Name is displayed in B2. If I change anything in Row 3, the date/time is displayed in A3 and User Name is displayed in B3, etc...
I would also like the words "UPDATED" in column C if a change happens in that Row and for the changed cells to be highlighted in YELLOW until the words "APPROVED" appear in that cell (will be from a validation list user can select from).
For the color, user can manually overwrite it just in case they put focus on it and then decide not to change anything.
Thank you!!!