Please check the spreadsheet , have explained everything there.
thnx
Please check the spreadsheet , have explained everything there.
thnx
Last edited by Sarangsood; 08-26-2013 at 04:10 AM.
sorry the spreadsheet wasn't opening the wright sheet when downloaded. it will now. thnx
place below in the code section of the Trng Rate sheet.
Please Login or Register to view this content.
If solved remember to mark Thread as solved , to mark your thread as Solved select Thread Tools and click Mark thread as Solved.
I can't read the mind of my wife so then I get picture but no sound .... and then I mostly get the idea, same goes here picture your outcome and I get the idea.
when the value comes to 1 , its not really executing the macro but only the message box is appearing.
also there are 4 macros which need to be executed automatically when the value of there related cell changes to 1 as shown in the attachment.
Last edited by Sarangsood; 08-26-2013 at 05:16 AM.
updated your file and replaced the message box with the actual call
sir you have almost done it. the problem now is that there is a formula in j23,j24,j26,j28. its not responding to the formula only if i manually enter 1, then it
responds. this is my actual sheet. thnx a ton
sir you have almost done it. the problem now is that there is a formula in j23,j24,j26,j28. its not responding to the formula only if i manually enter 1, then it
responds. this is my actual sheet. thnx a ton
is joke right ?
if i knew that from start it was way easier
put below in the code section of the Trng Rate sheet
Please Login or Register to view this content.
oops sorry my bad
okay i pasted the exact code. but my sheet freezes now ??
works fine here , please make sure you remove all previous code under the Trng Rate sheet
this is what i have done .try to type c in e23 , it hangs the whole sheet.
@hulpeloos - since he said "Please note the data is realtime. So the data in J23:J27 will change automatically.", I assume the data change that trigger the target cells changes are not on the same sheet (cause other sheets are referenced) -- A worksheet change event won't work then. Anyway - even if worksheet change would work, don't forget to add in Application.EnableEvents = False so it won't loop forever (which I suspect is happening now.
@Sarangsood - if the changes are actually caused by changes on other worksheets then the only way to go about it is to test for data changes for example every second and then run the macros accordingly.
Can you confirm that the changes are induced from other worksheets. If not, hulpeloos' code should work, just add
as first line after "Private Sub Worksheet_Change"Please Login or Register to view this content.
and add
as last line just before "End Sub"Please Login or Register to view this content.
Please click the * below if this helps
By the way, here's how I would do it.
Appoint one cell to be the "on / off" cell - in the example below, I took "P1". As long as there's a 1 in cell P1, the code will keep running and keep checking. As soon as you change that to anything else, the code will stop.
This will check the cells J23:J27 every second.
Put this code in your worksheet code area
Put this code in a modulePlease Login or Register to view this content.
Please click the * below if this helpsPlease Login or Register to view this content.
yes sir. the cells e23:e27 are from another sheet. first two from "aug" and the last two from "sep". the cells e23:e27 are the original one's which when changed should trigger the subsequent macros.
you can check the if formula in k23:k27 to understand better.
In that case, my solution should work, no?
did exactly what you said. now type "c" in e23 , it should change the value in j23 to 1. but the macro isn't executing??
It's cause I made a typo, sorry.
Change the module code as below :
Also, when you open the workbook, you need to enter "1" into P1 again to first start the macro. If you want to auto-start it, add this in your workbook code section :Please Login or Register to view this content.
Please remember to click the * below if this helpsPlease Login or Register to view this content.
wow works perfectly. thanks a lot
haven't tried it out with real time data because my office is closed for the day. but will surely let you know if something goes wrong
again appreciate it very much.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks