Multiple Source

G

Geoff Gant

Hi,
Is it possible to have a cell contain the value of the
latest change from a series of other cells which receive
data via DDE from different extenal sources?

I am looking to present sequential updates from various
sources via DDE to another application.

TIA

Geoff Gant
 
J

Jean-Paul Viel

Hi,



In the module of the sheet that receives the data put this code:



Private Sub Worksheet_Change(ByVal Target As Range)

range("a1").Value=target.Value

End Sub
 
Top