The following example demonstrates how to send data to Excel, manipulate the data, and return it to Embed in real time.
In the Embed window, the ActiveX write block named level writes a sinusoidal signal to Excel. The value is displayed in cell C3. Cell C4 displays the value of C3 plus 2. The sum is sent back to Embed through the ActiveX read block named poo.
A subroutine, shown in the Microsoft Visual Basic window, gets the data from level and displays it in cell C3; then writes the data from C4 to poo. This simple subroutine only updates the value of C4 and sends the data to Embed each time you click the mouse on a different cell.