Depends what you mean by real time. It would be easy to have the textbox
updated upon a certain event as long as the form is still up, just a simple

With MAINFORM
.DateTextBox.Text = Format(Date,"dd-mm-yy hh:mm:ss")
End With

If you want the textbox ticking over each second, then that is much more
complex. You would need a timer. You could use OnTime, but I would
personally use the Windows timer, and have a callback to manage the updates.

I could knock you up a sample workbook if you are interested, and you give
me your email address.

--

HTH

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

"scottnshelly " wrote in
message ...
Can we add the time to this to update in real-time?


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