what string?
just use
Format(TextBox1.Text,"hh:mm:ss")
--
HTH
Bob Phillips
(replace somewhere in email address with gmail if mailing direct)
"Zygan" wrote in
message ...
how can you format a userform textbox to display time ?
i have set the string as time format ????
how do i do this ?
--
Zygan
------------------------------------------------------------------------
Zygan's Profile:
http://www.excelforum.com/member.php...o&userid=34423
View this thread: http://www.excelforum.com/showthread...hreadid=560575