Hi,


I have many values that I retrieve from a trading software by RTD link (I can also retrieve it by DDE Link).

The Value that I retrieve is an Index value that changes about 2-3 times a second.


I would like to retrieve this values of the index for many cells, but just for the question matters lets say I would like to get the information for only one cell.

The way I would like to get the index value is only at a certain time. I've tried to using IF condition but it's all mass up, meaning:


If the time is 10:00 then cell A1 get the value.

The problem is that there's the "Else" part of the IF which I have to fill in, and when the time is 10:01, the cell get the value 0 (since it's no longer 10:00).


I'm sure that by VBA I can solve this, but unfortunately I do not know programming by VBA.


Can you think of a way to help me solve this please ?


P.S.1 I use Excel 2007.
P.S.2 For all it matters, The fact that I'm using RTD (Or DDE) link doesn't need to bother to the question.
The fact is that there's a cell that changes once a second (even more often..) and the need is to get a value in a certain exact time, and that this value will remain constant for the rest of the day without change even though the time will change after that second...

Thank you.