Hi,

the problem I am having is shown by the following example.

Cell A1 is formatted "mm:ss.00" and has the value 1:45.26 entered (note that the formula bar displays this as 12:01:45 AM).

I have a userform with a textbox and the following code is entered in the forms initialize event

TextBox1.Value = VBA.Format(Worksheets("sheet1").Range("A1"), "mm:ss.00")
When the form is opened the value displays as "12:45.00" whereas I was expecting (and wanting) "1:45.26"

Cheers

Jeff