Tom,

Take a look at the OnTime method in help. With this you can schedule forward
a macro to run. So you could set it to run in 5 secs, and when it runs, you
could do your thing, then schedule it to run again in another 5 secs.

--

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
...
Bob,

It didn't work unfortunately. I think it is because the actual content
of the cell did not change. I mean the (=SIPART|'DR24'!SAA8) is always
the same. I added another textbox to the form that sent a value to cell
A1. It then came back into textbox1. Do you get what I mean?

I can also get values directly in my userform with the DDERequest
command. Again I have the continuous and automatic update problem.
Isn't there any kind of looping that would send this command every
second or 0.5 seconds without locking up other controls on the same
userform?

Thanks again for you interest.

Tom


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