Show if cell is greater or smaller than previous value

You can declare a couple of public variables. Then use them in a Worksheet_change event macro.

Each time the "watched" cell changes, public variable TWO value become public variable ONE value, public variable ONE value value becomes the new "watched" cell value.

Then a simple equation against those two variable will tell if things are going up or down.

1) Right-click on the sheet tab and select VIEW CODE
2) Paste in this event macro:

Please Login or Register  to view this content.

3) Close the editor and save your sheet

Now manually change the value in C4 or wait for your web query to do it and the C5 status will update automatically.

It should operate the same way. I've used ws_change events in conjunction with web queries before and they work great together.


If that takes care of your need, be sure to EDIT your original post, click Go Advanced and mark the PREFIX box [SOLVED].



(Also, use the blue "scales" icon in our posts to leave Reputation Feedback, it is appreciated)

A DDE update will not invoke the Change event, only the Calculate event (like other formulae).

Given a calculation event can be invoked by actions other than the update of the DDE I would suggest using a Static variable in the Calculate event such that you can compare pre & run-time values of DDE so as to determine alteration and subsequently, when applicable, direction.

EDIT: thread below has different final requirement but same premise - ie capturing DDE change and acting accordingly, does outline basic premise of using Static variable etc...
http://www.excelforum.com/excel-prog...her-sheet.html

Don, the macro given above won't work if it's changed to a Worksheet_Calculate event instead? I've never used DDE so I can't test that.

There is no Target.

You would want a Static variable which at run time will be the "last known value" for the given Range, then compare current to Static - if it's changed then you know the cell in question has recalculated at which point you can conduct whichever acts are required before setting the Static variable to be the current value (toggling events appropriately).

In this instance given a DDE can quite feasibly update without changing (ie same price) the fact that OP is interested in movement alone actually simplifies things (considerably)

I believe we have a crosspost here:
http://www.mrexcel.com/forum/showthread.php?t=429368

==============
So the original macro adjusted like so:

Please Login or Register  to view this content.

Re: cross post - it would appear as though there has been a misunderstanding - Warning will be reversed.