Userform time search

[cascao]

Hello How are you?

I have a form with a textbox in excel where I write a term and appear in a listbox the words with that term.

Works well with text, not time.

If I try search for hours, only when I type 0 (appears 1:30:00 to 23:30:00) or 1 (appears 24:00:00 to 47:30:00).

I'd like to search for time. Is it possible?

Thanks in advance.

[Toonies]

hi can you give an example of the code as it will help when trying to solve your problem

[Toonies]

Hi take a look at this it may help

http://www.ozgrid.com/forum/showthread.php?t=123245

[cascao]

I use =TEXT("x:xx:xx"; "[h]:mm:ss"). Now works.