Say:
A36 = 80
I want to create a macro, that will inform me every time the cell 'A36' becomes smaller, or decreases in value... In the pop-up box I want it to say something like, '100m Test Required (20/10)'
Please Help if you can!
Leah
Say:
A36 = 80
I want to create a macro, that will inform me every time the cell 'A36' becomes smaller, or decreases in value... In the pop-up box I want it to say something like, '100m Test Required (20/10)'
Please Help if you can!
Leah
If A36=80, why would it change?
Is it a formula?
Yes Dave, there is a formula in this cell which calculates the running total of a range above it, and resets this number after it hits 100.. the formula is: A36==MOD(SUM(A2:A35),100)
Please Help
There is a three step macro (but simple) process...
In the sheet that contains the code (assuming it is Sheet 1) put this code:
In a standard module, put this code:Please Login or Register to view this content.
In ThisWorkbook, put this code:Please Login or Register to view this content.
Please Login or Register to view this content.
It simply does the following:
1) When you open the workbook, the variable OldValue is assigned whatever the value of A36 is Sheet 1.
2) When you make a change on Sheet 1, it will check the current value of A36 against OldValue. If OldValue is bigger this will trigger the messagebox.
3) It will reassign the new value in A36 to OldValue.
Let me know if you have any questions or changes.
abousetta
Please consider:
Thanking those who helped you. Click the star icon in the lower left part of the contributor's post and add Reputation.
Cleaning up when you're done. Mark your thread [SOLVED] if you received your answer.
Can you please provide me with steps on how and where to enter each of the 3 codes? I am only new to macros.. It sounds as if it will work so thankyou very much however I do not want A36 to change to 'OldValue' I want the value to stay the same ...
Leah
Spreadsheet.xlsxCould you please put the correct formulas in, and send the workbook back .. asap, this is rather urgent
Thankyou for all your help!
never mind I got it all to work Thankyou so much!
One more question... I need this macro to be relevant not only for A36 but also the range of A36:N36, but with different messages, please help?
Do you want it for each cell or any cell between A36 and N36?
For each cell, and also on numerous sheets :/
OK... a different approach is called for. Here is the best option I could think of. I have now used a 14 X 6 array to track all the cells at one time. The new updated code is in the attachment and seems to be working fine. The same message comes up each time, but you can customize it per sheet. If you need help, let me know.
abousetta
P.S. This is now an old example, please new attachment in later post.
Last edited by abousetta; 04-03-2012 at 08:33 AM. Reason: Outdated attachment. See example below for new one.
Post deleted...
New code in later post
Last edited by abousetta; 04-03-2012 at 08:34 AM.
You have been a great help, thankyou Abousetta
sorry for asking soo many questions but I was just wondering how I am meant to change the message for each separate cell (20/20) ( 25/20) etc. I understand how to change the message in the popup box for each separate sheet, just not for each cell :/
Thankyou alot again!
Hi,
There a million and one ways to customize it so if you can tell me how you want the message box to customized I can see what I can do. I have updated all the code and added a unique message for each cell to tell you which cell on which sheet triggered the message box to display. Let me know if you need anything further.
Good luck.
abousetta
Thankyou, Abousetta! You have solved the problem and been a wonderful help
Much Appreciated,
Leah
Glad I could be of assistance and thanks for the feedback. If you are satisfied with the responses then please mark the thread as solved.
Good luck.
abousetta
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks