the following code works well for me but when i put a formula in A1 or link it from somewhere it stops working
plz help me convert this code![]()
Please Login or Register to view this content.
the following code works well for me but when i put a formula in A1 or link it from somewhere it stops working
plz help me convert this code![]()
Please Login or Register to view this content.
Worksheet change only works off of physically triggered manual changes in cells. If you want this code to trigger every time the FORMULA in cell A1 changes value, then you'll need a different approach.
Is that what you want? If A1 ever changes value, trigger this "log" event? By the way, WHAT is in A1? A number, a decimal number, a text string?
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
yes sir thats exactly what i want ... A1 contains a formula (=ROUND(G1/5,0)*5) , where G1 is running live stock market rate.
Try this instead:
![]()
Please Login or Register to view this content.
Last edited by JBeaucaire; 09-20-2011 at 03:29 AM. Reason: corrected number format
its working , but now after the conversion it has started behaving differently.
in the first code it used to copy the change in cell (when done manually) to B2 , then when it changes again to B3 and so on.
now somehow its copying the change in cell to B2 till B98.
What conversion?
conversion as in the new code which you have written
its working well with the change in value of the formula but its doing something different now when the change in A1 occurs
I don't understand what you're saying. The code simply watches the value in A1. If it changes, it registers the new value in column B with a timestamp.
i am having some problem running the code in live feed. it starts copying the value of A1 in column B till B98 and then excel crashes.
![]()
Please Login or Register to view this content.
Last edited by mikerickson; 09-20-2011 at 04:35 AM.
_
...How to Cross-post politely...
..Wrap code by selecting the code and clicking the # or read this. Thank you.
I'll be happy to examine your workbook.
it still isnt working on the live feed . when i link A1 with G1 then the program works perfect but when i link it with H1 (live feed) then it doesnt respond. i have attached the file.
You're using something external, Chart.exe, that I cannot troubleshoot.
You're using Mike's macro, so I'll let him respond. Hope you figure it out.
Apparently the live feed doesn't trigger a Change event. It looks like JBeaucaire's code would be the way to go.
i found a function
it isnt doing the trick on the live feed , perhaps you could alter it![]()
Please Login or Register to view this content.
i found a function
it isnt doing the trick on the live feed , perhaps you could alter it![]()
Please Login or Register to view this content.
Why would I? That function seems non-relevant and the code I gave is giving me timestamps down my sample workbook forever, until I turn it off.
Your crashing problem is being caused by something as yet undisclosed, possibly in that CHART.EXE it seems to reference. The macro provided is very basic and does the job described.
ok thanks sir ... i tried using it in another feed but it crashed again ... maybe some problem with the live feed ... i appreciate your time .
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks