Not showing value time in TextBox and ListBox

To anyone, please help

I have an UserForm with TekstBox2 to fill in Time (mm:ss). It writes the entries to the sheet nicely. But when I look for a special record in de ListBox, time shows as Numberformat 0,5441 instead of mm:ss.
When I select a record out of the listbox, the TextBox2 showes that numberformat instead mm:ss.

Can anybody help me with a Code to show the right format in de ListBox and TextBox?

Sorry

I don't understand. The next code I have for wrighting to the ListBox:

With Me 'load entry to form
.ComboBox2.Value = c.Offset(0, 0).Value
.ComboBox4.Value = c.Offset(0, 1).Value
.TextBox2.Value = c.Offset(0, 2).Value
.TextBox4.Value = c.Offset(0, 3).Value
.TextBox3.Value = c.Offset(0, 4).Value
.ComboBox5.Value = c.Offset(0, 5).Value
.ComboBox3.Value = c.Offset(0, 6).Value
.TextBox8.Value = c.Offset(0, 7).Value
.TextBox5.Value = c.Offset(0, 8).Value
.TextBox6.Value = c.Offset(0, 9).Value
.TextBox9.Value = c.Offset(0, 10).Value
.TextBox10.Value = c.Offset(0, 11).Value

TextBox3 and TextBox10 are the timefields. Where do I write your code?

regards

I Tried, is still not working.
Sorry

I am at work now. I have tot uploap from home. So it take a time, sorry

hereby

thks


Module storing blanco.xlsm

Hi

Thanks for your effort sofar. Still the Userform not showes the time.

regards

Hi

I am a beginner with VBA. In the Userform (and listbox) I see the time as a number instead time notation. In the sheet is all ok. Time stays time.

with regards

Hi

I have changed the dutch names into englisch names. When you go to find object and choose in the comboBox for Test1 and presse the OK button then the ListBox shows you 4 records.In collumn Time1 you see a nummer instead a time. In the sheet1 is the correct time.
When you select a row, in the TextBox "Time1" filled in a number instead time.

How can I show in the ListBox and in the TextBox "Time1" the correct value?

best regards

Sorry

I added the wrong xlsm

Thank you very muth. Its working!