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

  • Thread starter Thread starter mightyginger
  • Start date Start date
M

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.
 
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




mightyginger said:
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.


------------------------------------------------



~~Now Available: Financial Statements.xls, a step by step guide to
Click to expand...
creating financial statements
 
Back
Top