OnChange - argh! How do I get this to work please?

[mightyginger]

First post here guys.

I'm getting stock prices from retuers. The cells with the feed in it
updates with the price. I need some code which says "when this cell
changes, and only this cell" run this sub.

I've used OnChange but it only seems to work when you manually change a
cell. No good. Oncalculate is just too much as the spreadsheet becomes
unusable and there is no need to reculated everything if the price
doesn't change.

Any help would be greatly appreciated!


Thanks,



Neil.

 

[Tom Ogilvy]

Look at setlinkondata This is set for each individual link (you have to
have code that sets it) and the assigned macro fires when that link updates.


If you have excel 2000 or later, you can use the Change event as well.

--
Regards,
Tom Ogilvy

First post here guys.

I'm getting stock prices from retuers. The cells with the feed in it
updates with the price. I need some code which says "when this cell
changes, and only this cell" run this sub.

I've used OnChange but it only seems to work when you manually change a
cell. No good. Oncalculate is just too much as the spreadsheet becomes
unusable and there is no need to reculated everything if the price
doesn't change.

Any help would be greatly appreciated!


Thanks,



Neil.

creating financial statements