Searchable combobox in excel vba userform with time format

[Vishwanath Korgaonkar]

Hi-
I have a combobox with rowsource in time format for example 10:00 AM .It has data with time at 5 minutes interval. I am looking for code with searchable combo box where if I type 10 it should drop down list starting from 10:00 AM

I have tried all the codes from different sources available on net but not able to get solution.
Kindly help to get the code
thanking you in anticipation

 

[DanteAmor]

Is there codes which displays AM and PM when I type 10

Just change this line:

If Format(c.Value, "hh:mm:ss") Like dato & "*" Then

For this line:

If Format(c.Value, "hh:mm:ss AM/PM") Like dato & "*" Then

 

[Vishwanath Korgaonkar]

Thanks DanteAmor,
It works perfectly

 

[DanteAmor]

I'm glad to help you. Thanks for the feedback.