? Format (Time, "hh:mm")
15:46


No reason it shouldn't work. Where is the code. The textbox isn't linked
to a cell is it?

--
Regards,
Tom Ogilvy

"Pete T" wrote in message
om...
As soon as I thought I was done with my VBA programming, I get pulled
back in. I have UserForms which pull data from a selected row, the
staff then can update and edit the data to move to a Database....

However, now I find that when the data is pulled, all data is fine,
even the Data textbox (EDate), but the (ETime)textbox shows time as a
decimal (.375, rtc.) I have tried various forms of formatting such as:

ETime.Text = Format (Time, "hh:mm"), but I always get the same Compile
Error, Wrong number of arguments .....

This is very frustrating as I am very near finished. Thanks for any
help.