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

 

[hopr37]

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

Tried doing this but I keep getting a "macro cannot run" error even tho I've used buttons and macros in the past

 

[hopr37]

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

MickG:
entered all the code but upon hitting the first button after making changes , it does nothing.
upon hitting the second button gives a runtime error mismatch at:
Erase Ray

I'm assuming i get the error because nothing is being recorded

 

[MickG]

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

If you mean you have placed the code shown on the sheet (example only) into the various code modules, then I should try downloading the example again because all the code was already in place and the code shown on the sheet was only there to show you what it consisted of.

You should only need to change any one of the cell "A1:A3" to show a result when "Get Results" commandButton is clicked..
Regrds mick

 

[hopr37]

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

If you mean you have placed the code shown on the sheet (example only) into the various code modules, then I should try downloading the example again because all the code was already in place and the code shown on the sheet was only there to show you what it consisted of.

You should only need to change any one of the cell "A1:A3" to show a result when "Get Results" commandButton is clicked..
Regrds mick

I have already changed the cell values to "D" values. But I changed all cell values that had "A' in them to "D"
However, I didn't see the download button to see the example in action. Duh. I will try that first and let you know.

 

[MickG]

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

I don't know what you mean, you only need to change any cell in range "A1:A3", and there was no "D" value or "A" values there !!!!:-
Have downloaded the file again or got a result ???

 

[hopr37]

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

I don't know what you mean, you only need to change any cell in range "A1:A3", and there was no "D" value or "A" values there !!!!:-
Have downloaded the file again or got a result ???

Sorry, I meant where you have the A1: A3
I changed that to D5:D100

Looking at the example now

 

[MickG]

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

You don't want to change anything to start with, just get it working first.

 

[hopr37]

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

ok

 

[hopr37]

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

so it owrks except getting a message that says "no data held"
Will figure that out. I'm sure it's a range thing.
I see the problem. It isn't copying over to sheet2...

 

[hopr37]

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

Not sure how to change the portion that copies the data to sheet2.
looking...