Checking and Updating

[Robert Couchman]

Hi All,

please can anyone help?

i can call up a piece of information from anywhere on my
spreadsheet, but i want to know the VB code so that when i
go to close the window, if it sees that the data has been
updated then it askes the user if they would like to save
changes, then it will input the new updated data into the
correct fields.

can anyone please help?

Thank you,

Robert Couchman

 

[Tom Ogilvy]

based on your vague description, you would need to maintain a record of all
values that could be changed and check against each of these values with the
current values to see it they actually were changed.

You could trigger the checking in the beforeclose event.

Any solution would have to be specific to you situation which is so vague at
this point that it would not seem worthwhile to suggest anything specific.