G
Guest
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
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