How do i change a UserForm Label Format to Time?

[whcmelvin]

History.Label1.Caption = Sheets(Sheet1).Range("H2")

Range H2 in my excel is already in time format. but when i reference to the label, it gave me lots lot of number.

I have tried this but it do not work as well

Format(History.Label1.Caption = Sheets(Sheet1).Range("H2")

 

[VoG]

Try

History.Label1.Caption = Sheets(Sheet1).Range("H2").Text

 

[whcmelvin]

Is still the same. the Label caption did not show the time. it showed alot of numbers instead

 

[VoG]

I entered a time in Sheet1!H2 then ran this

Sub atest()
History.Label1.Caption = Sheets("Sheet1").Range("H2").Text
History.Show
End Sub

The userform displayed the time as hh:mm format.

 

[whcmelvin]

Yup it worked. Thanks very much