Hi, Using XL 2000

My worksheet contains numerical values in Cols A, B, C & D.
Cols E & F Contain Contact Names. There are over 100 rows of data

In my userform, a user selects a numerical value in Combobox1 and combobox2

On a click event, I would like the following to execute:-

The value selected in CB1 is checked against every row and where it is
greater than value in Col A AND less than the value in Col B, reports True

The value selected in CB2 is checked against every row and where it is
greater than value in Col C AND less than the value in Col D, reports True

Only where 2 True's are present, I need the values in Cols e & F in the
respective row that meets the true condition to be added to ListBox1.

I hope i've manged to explain my problem.
Any VBA ideas welcome.

Thank you.

Paul