Error when populating cell with “Time” from combo box in user form

[jwala]

Dear Members

In my user form " I AM USING COMBO BOX, FOR FILLING TIME"


Error is :

a. Time is showing in "DECIMAL FORMAT ( Example: 9:00 showing as "0.375") in the text box of user form

b. I am using "ROW SOURCE" only from another worksheet, as the source for combo box

Regards
jwala

[sweep]

A quick search of the forum yielded this

[jwala]

Dear Members

I got solution form the forum for the abvoe errro:

I am using the following code to slove the error:

Please Login or Register  to view this content.

Regards
Jwala

[jwala]

Dear Member

Thank you for your time, i got the solution from the forum search

Regards
Jwala

[royUK]

There's an example that might help. It uses 3 comboboxes - Hour, Minute & Second

Combo_Time.zip