Multiple Source

  • Thread starter Thread starter Geoff Gant
  • Start date Start date
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
 
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
 
JP,
I have emailed you off group.

B rgds,
Geoff
-----Original Message-----
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





--
JP
(e-mail address removed)
http://www.solutionsvba.com





.
Click to expand...
 
Back
Top