Sum minutes to Combobox

[Ramses28]

I want to sum 10 minutes to a combobox (the combobox is filled with an hour in format "hh:mm").

I used the code:

ComboBox2.value = (Format(ComboBox2.Value, "hh:mm")) + (Format("00:10", "hh:mm"))

but it doesn't sum the 10 minutes and i don't understand why?

Thanks in advance

 

[Yongle]

Try this

Private Sub CommandButton1_Click()
ComboBox2.Value = TimeValue(ComboBox2.Value) + TimeValue("00:10")
End Sub

 

[Ramses28]

Thats it!!
The combobox changes to the format to "10:10:00 AM". Is it possible to convert to just "10:10"??
Thanks Yongle

 

[Yongle]

Try this

Private Sub CommandButton1_Click()
    With ComboBox2
        .Value = TimeValue(.Value) + TimeValue("00:10")
        .Value = Format(.Value, "hh:mm")
    End With
End Sub

 

[Ramses28]

Doesn't work.
Returns an error: "invalid property value".
Don't now why.

 

[Yongle]

Method tested here
- it works (both userform and on-sheet embedded active-x)

Where is your combobox?

 

[Ramses28]

Figured out the issue.
The combobox style was wrong. it was defined as dropdownlist. i changed it to combo and the code works perfectly.
Thanks a lot!