Using Input boxes for autofilter code

[VKS]

Dear Experts,

I am using a code to autofilter my data and am looking for help in making it more dynamic by using input boxes to filter one more column

Column 16 has time values shown as 1:00:00 AM (0:01 to 23:59).

How can I use input boxes to select start time and end time to autofilter my table.

For example in first box I put 01:00 and in second box I put 04:00 and it gives all the values between 01:00 and 04:00

Please Login or Register  to view this content.

Thanks/VKS

[mohan.pandey87]

you can give criteria like this:

Please Login or Register  to view this content.

[VKS]

Thanks for your help Mohan but it gives me the first row only (Headers).
Best Regards/VKS