Search box no longer working

**Akela928** · 09-28-2023, 08:48 AM

The attached document was working but now has failed on two fronts and I can't determine why. I can no longer see the typed text in the search box until I move my cursor to another cell. And, every search results in "No Records Found". Not sure what has happened here but any assistance would be great. Tab 1 is the search function and Tab two is data sheet.

**jindon** · 09-28-2023, 10:02 AM

1) I can type in and am able to see the text.

2) Search column references in your formula were wrong.

Formula:

Please Login or Register  to view this content.

**6StringJazzer** · 09-28-2023, 10:12 AM

I had no problem typing into the boxes. I don't know what's wrong with your search formula but I just rewrote it from scratch.

=IFERROR(FILTER('Contract Main'!$B$5:$I$20,(($B$4<>"")*(ISNUMBER(FIND($B$4,'Contract Main'!$B$5:$B$20)))) + (($B$5<>"")*(ISNUMBER(FIND($B$5,'Contract Main'!$F$5:$F$20))))),"")

**Akela928** · 09-28-2023, 10:23 AM

Thank you, I will correct the references, but I don't understand why you can type in the file box and I can't. I think I will remove those rows in their entirety and then insert new rows and re-create the search boxes. Hopefully that will fix the issue.

**Akuini** · 09-28-2023, 10:51 AM

I want to comment on something, in your workbook you said:
"5) DO NOT SAVE document when closing, this will protect the integrity of the document"
If you don't want users to save the workbook, you can do this:
Put this code in ThisWorkbook code module:

Please Login or Register  to view this content.

In order to save this macro you need to do this in Design Mode: in the ribbon > Developer > Design Mode > Save the workbook.
Hopefully users don't know this method.