Tom,

I think you need some event to update the textbox, just changing the
ControlSource may not be enough. I don't know what code you are using to
write to the spreadsheet, but could this not be directed to the textbox at
this point? If not, perhaps worksheet event code would do it, that is write
to AA6 and trap that change of AA^ to write to the textbox.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Tom_C " wrote in message
...
I am having a problems getting a texbox on a userform to update
dynamcally (updated without user interaction). I am getting
measurements which are changing continuously and would like to monitor
them in real time. I can see the values by using a DDERequest, but I
must always click something to get an update. Or I can put the
following (=SIPART|'DR24'!SAA6) in an Excel cell and it will monitor
the signal in real time, but I cannot get this to update in the
textbox. Using the ControlSource of the text box would work, but it
overwrites the code (=SIPART|'DR24'!SAA6) in the referenced cell.

Can any one help?

Thank you!


---
Message posted from http://www.ExcelForum.com/