pop up message that tells you all the changes you made to a spreadsheet

[hopr37]

I use a lot of data entry on my spreadsheet.
Is there a way to create a message box that will tell me the entries that I made during the day?
I have 3 different cells that would need to be displayed.
the first cell ( cell A) is just a description
the second cell ( Cell B) is an amount that I input
the third cell ( Cell C) is an amount that is subtracted from the second cell.

So as an example if I made 3 changes I could hit a button and a message would pop up indicated the 3 cells and what was done with them.
"you have changed:
"description, amount, amount"
"description, amount, amount"
description, amount, amount"

and then reset if I close the worksheet.

Thank You

 

[MickG]

Re: pop up message tht tells you all the changes you made to a spreadsheet

In my Copy of the file, I have just altered the 3 cells 3 times and I now have 9 results on the Msgbox and 9 results on sheet2.
The "Get results" code sends the data to sheet2.

Have you altered any of the code, if not and you still have the problem, scrap the files you have, and down load the file afresh.
Try the code out, but don't alter it until you are happy with its functionality.
When you understand what you have got, think how you would like to alter it , and let me know.

 

[hopr37]

Re: pop up message tht tells you all the changes you made to a spreadsheet

will do.
Thanks

 

[hopr37]

Re: pop up message tht tells you all the changes you made to a spreadsheet

nope. Just can't get sheet2 to populate.
The window comes up so it's obviously running thru the macro

 

[hopr37]

Re: pop up message tht tells you all the changes you made to a spreadsheet

any other takers?

 

[hopr37]

Re: pop up message tht tells you all the changes you made to a spreadsheet

jmacleary:

I recieved your sample.
having the same issue.
message box comes up but it's empty.

I've used other message macros that have worked but for some reason yours works as it should except there is nothing in the box.

 

[hopr37]

Re: pop up message tht tells you all the changes you made to a spreadsheet

Got it figured out. Thanks for everyone's help