Check if there is a change in cell

[GEMINI528]

Good day Excel Gurus,

I have the working VBA code below but I need some revision. The code below checks every cell if there is a change. Example, If I made change on cell “D9”, it will ask “Do you want to save changes…?” and also same with “D10”, “D11”, and so on.

What revision I want is when you reach “D42”, or when I exit on the loop that the only time it will check if there are changes made on the sheet.

Any help would be appreciated.

Thank you.

Please Login or Register  to view this content.

[Logit]

.
You want to be notified if a change occurs ANYWHERE on the sheet ?

[GEMINI528]

.
You want to be notified if a change occurs ANYWHERE on the sheet ?

Yes sir. If there are more than 1 changes, I would like the notification once only NOT every time I change the value of each cell.

Thank you for your prompt response.

[Logit]

.
Hmmm .... help me understand.

At first I was thinking you wanted to create a log on another sheet that would list all the changes someone might make to your workbook.

I am now thinking you want to be asked if the changes should be SAVED ?

If that is correct, rather than using the Worksheet_Change(ByVal Target As Range) event ... perhaps asking when the workbook closes ?


Maybe a more complete description / explanation of your work process .... goal ... is in order ?

[GEMINI528]

Sorry for the confusion...

Well, theoretically the workbook is being save. There are 2 Macro, when there are changes, you have the option to save it, “Sub UpdateLogRecord()”, If you don’t want to save it, It will just clear the sheet “Sub ClearDataEntry()”, If it is cleared, it will not be stored when you save the workbook.

Thank you.

[Logit]

.
Gotcha !

There are several things you will need to do to accomplish your goal.

In the ThisWorkbook module, you can place this macro :

Please Login or Register  to view this content.

The SaveOrNotMacro (or any other name you like) is the macro you will create in a Regular Module. This macro will give the user the opportunity to
save or not save the changes made .... when they close the workbook.

The macro will have similar logic from your posted macro :

Please Login or Register  to view this content.

I haven't tested the above macro here. There may be some required changes.