Userform Textbox Time Display

[DKTRL]

Dear All

Did anyone know how to format textbox to display time in this manner 00:00 ?

currently i am using a userform to import data from a worksheet. but instead of the time on the worksheet is display 09:00 after import to the userform textbox it became 0.375.

Hope someone can give me a help !


Thanks !

 

[BrianMH]

Excel forms are limited in what they can do. You won't be able to set a time format in the textbox on an excel userform. You will need to format it when populating. So where your code is pulling through the time you can use the format option.

tb1 = Format(yourtimevalue,"HH:MM")

 

[DKTRL]

Excel forms are limited in what they can do. You won't be able to set a time format in the textbox on an excel userform. You will need to format it when populating. So where your code is pulling through the time you can use the format option.

tb1 = Format(yourtimevalue,"HH:MM")

Dear Brian

Thanks for your respond, i have try a lot format that read from the forums, but non of them is work. and finally got this formula to work .

Thanks

me.Textbox1.value = Format(Worksheets("sheet1").Range("A1"),"hh:mm")