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

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.


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/

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

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

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" wrote in message
...

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.


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/

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