Filter sheet data with ComboBoxes, then Update UserForm with filtered sheet data

Hi all,

I hope you can help me. This is a 2 part issue.

I have a dropdown ComboBox filter method i would like to use on a UserForm for filtering my data.

But the code does not always work properly

1. i get a lot of Run-time errors (1004) "No cells were found" - especially now that I am using it to filter and select dates or times. I don't know if has to do with the format?
2. Also, how can the code be modified that the row that is filtered can be used to update my UserForm fields with the filtered data?

Below is my PREVIOUS search function code used for updating my userform - I would like to accomplish the same effect using the ComboBoxes (drop-downs):

UserForm Code:

Please Login or Register  to view this content.

Module Code:

Please Login or Register  to view this content.

Thank you!