the easiest approach in my opinion is to load the textbox with a string
rather than using a control source. Clear your control source and in the
userform initialize event

Textbox1.Text = Worksheets(1).Range("A1").Text

--
Regards,
Tom Ogilvy


"scrabtree23" wrote in message
...
On a userform, I placed a text box that ties to a cell in
a worksheet that displays a time. However, the text box
converts the time to serial code. How do I make the text
box display the time as time?

SDC