Populate listbox if search reference is duplicated

[rayexcel]

Hi

my userform searches based on the date. If it finds something it populates an amount into another textbox. So it is searching the date in column(A) then returning the corresponding value in column(B). If the date is duplicated it is meant to populate a listbox with all the dates and corresponding values which are duplicated.

I think it has something to do with the fact im searching based on the date, as I have another userform which searches based on a number and it does as it should.

So heres the code for the whole userform, the find features are in Sub cmbFind and SUb FindALL.

Please Login or Register  to view this content.

[Tinbendr]

Please Login or Register  to view this content.

Also, check out this article (scroll to the bottom) about using Range Find to search for dates.

[rayexcel]

That article suggests using datevalue as the formatting method, if i used datevalue() instead of cdbl() would that run smoother?

But tried changing to what you said but still that didn't fix it

[Tinbendr]

... tried changing to what you said but still that didn't fix it

Then we'll need a sample workbook.