Hello everyone,
I have a spreadsheet that takes a DDE input and displays it in cells that the user defines. The DDE input constantly updates; as the value changes on the DDE server, the value in the cell changes. I'd like to record every value that runs through the DDE cell to be recorded in the form of a list. here is an example:
lets say the cell with the DDE reference updates every two (2) minutes, which is technically not important. I'd like to place the first value in "cell 1" of my list. when the DDE cell value changes to the next value, I'd like to record that value in "cell 2" of my list, and so on for as long as the DDE server is linked to the excel spreadsheet, therefor the list will continue to grow every two minutes when the DDE cell value changes.
This will be used to link multiple programs running at the same time, so I can run real time calculations on data coming in from a test I'm running.
I'm open to any solution, regular equations, VBA, etc.
Thanks in advance!
I have a spreadsheet that takes a DDE input and displays it in cells that the user defines. The DDE input constantly updates; as the value changes on the DDE server, the value in the cell changes. I'd like to record every value that runs through the DDE cell to be recorded in the form of a list. here is an example:
lets say the cell with the DDE reference updates every two (2) minutes, which is technically not important. I'd like to place the first value in "cell 1" of my list. when the DDE cell value changes to the next value, I'd like to record that value in "cell 2" of my list, and so on for as long as the DDE server is linked to the excel spreadsheet, therefor the list will continue to grow every two minutes when the DDE cell value changes.
This will be used to link multiple programs running at the same time, so I can run real time calculations on data coming in from a test I'm running.
I'm open to any solution, regular equations, VBA, etc.
Thanks in advance!
