entering time values

[Atishoo]

Im using a userform to enter a time into a cell, I am currently using a
combobox with a list fill range that contains times, when i select a time it
appears in the combobox as a decimal, is there a way of changing this or
alternatively is there just a better way of entering time values other than a
combobox?

 

[CurlyDave]

Im using a userform to enter a time into a cell, I am currently using a
combobox with a list fill range that contains times, when i select a timeit
appears in the combobox as a decimal, is there a way of changing this or
alternatively is there just a better way of entering time values other than a
combobox?

Try

Private Sub ComboBox1_Change()
ComboBox1.Value = Format(ComboBox1.Value, "h:mm:ss AM/PM")

End Sub