change event for an external link

vvershas

New Member
Joined
Apr 6, 2002
Messages
20
hello,
I need to copy and paste a range of data whenever a particular cell's value changes. this particular cell is updated by an external link. I've played around with the change and the calculate event. The change event will only work if I update the cell and click out of it.
I also need this range of data to go to the next column each time the cell is updated so that i can compare changes since the previous update.
any help would be very appreciated
 

Excel Facts

What does custom number format of ;;; mean?
Three semi-colons will hide the value in the cell. Although most people use white font instead.
Hi
You can accomplish this via the calculate event. I wrote a trade tracking program for several people which tracks prices and volume changed and automatically records changes on the next row/column. If you'd like, I'll send it to you. Is an Excel spreadsheet. Maybe the source code can help you out a bit.
Tom
 
Upvote 0
Hi Tom,
Thanks for the info. Your spreadsheet sounds ideal so please do send it. The spreadsheet I'm working on analyses tote betting from a terminal session so it's very similar to stock analysis.

Cheers
Shaun
 
Upvote 0
thanks Tom
the calculate event seems to be for in the event of any cell in the sheet recalculating. how can I set it so that it is in the event of only 1 particular cell recalculating?

cheers
 
Upvote 0
Hi
I suppose you may have to work around this by reserving one sheet to be the sole reciever of your query updates. I'm not sure exactly what your are doing so it is quite difficult for me to understand how I might help you. The sheet I sent you recieves updates for four items. Time, Date, Price, and volume. I attempted to capture the changes for Price and volume only.
You may need to store a previous value and then compare it to the new value, if any, to detect a change in the cells in which your query are concerned.
I believe that is how I did it.
If you really get stuck, send me a sample stream of your data and I will try and figure it out. As you can see by my code, I am no expert, but it does work for the purpose that I created it for. At least that's what I'm told.
Tom
This message was edited by TsTom on 2002-04-07 18:18
 
Upvote 0
Tom,

I'll re phrase that last question,
all examples i have seen are in the case of a cell having a particular value.
I need to invoke a sub if the cell changes to any new value. (in my case, an update in the win pool on the tote)

cheers
 
Upvote 0
I edited my former reply.
The workbook I sent you captures the link change via the calculation event. Because I know of no way to determine which cells provoked the event, I store the previous value from the link, compare it to the new, if any, and then run my code from there.
So it does not really matter which cell caused the event to fire off. It only matters that the values we are concerned with have changed or not.
Do you understand?
Tom
 
Upvote 0
The workbook I sent you is based soley upon changing values. If a price or volume changes then the code sends the new values, along with the date and time, to a new line/row. This seems to be what you are after?
 
Upvote 0

Forum statistics

Threads
1,213,497
Messages
6,113,998
Members
448,539
Latest member
alex78

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top