Prompt user to add a comment if cell is changed.

[jayman5585]

Hello,

I'm creating a time keeping system for the company I'm currently working for. Is it possible to track changes made to cells and have a pop up dialog box that will allow the user to add a reason why they are changing the cell. For instance, If I work 8 hours on Monday at the office but when I get home I work an additional hour. When I change the cell from 8 to 9 I would like to add the reason for the change.

This is the spreadsheet I am using. Thanks in advance for any help offered!

Timesheet Test.xlsx

[Leith Ross]

Hello jayman5585,

I wrote this macro awhile back to time stamp cells and made a few changes for your needs. I have added the macros below to the attached workbook. Let me know if you need any changes.

Worksheet Change Event Code

Please Login or Register  to view this content.

Module1 Macro Code

Please Login or Register  to view this content.

[jayman5585]

Leith,

Thank you so much for your reply. This will work perfectly for my needs!

Thank you again for the quick response!!

[Leith Ross]

Hello jayman5585,

You're welcome. It's nice to hear it works the first time and no changes are needed.

[jayman5585]

Leith,

Is there a way to modify the code so the comment box will only appear if you change an already populated cell? Say I change a cell from blank to 8 nothing happens but if I change the cell from 8 to 9 I get the pop up message asking if I want to make a comment.

[Leith Ross]

Hello Jayman5585,

It took a couple of changes to make this happen. Here is the code. There is now an extra worksheet event macro. This records the cell value before the the user changes the value. Just copy and paste these code into workbook. If you have any problems, let me know.

Worksheet Event Macro Code

Please Login or Register  to view this content.

Module1 Macro Code to Timestamp the Cell

Please Login or Register  to view this content.

[jayman5585]

Awesome! This is perfect! Thank you so much for your help!!

[Leith Ross]

Hello Jayman5585,

You're welcome.