Checking and Updating

  • Thread starter Thread starter Robert Couchman
  • Start date Start date
R

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
 
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.
 
Back
Top