Fuzzy number search

Hi, I'm using a search box macro to find data.
Currently it works great for any Text based entry being searched for, but when searching for a number it only searches for text with the numbers contained in the text or for the exact number.
I've tried but I can't get it to search for the number entered in the search box, within a number OR within text
I'm sorry if that sounds confusing.
Here is my code;

Please Login or Register  to view this content.

I will attach a sample worksheet in just a short moment
File Room Records .xlsm

Edit; My apologies I misunderstood

Re-enter (or convert) the case numbers on the sheet that are all numeric as text.
--Enter a case number like '126587 with a leading single quote
--Or format column B as text and reenter the numeric case numbers.

Then change your code to always search for text.

Please Login or Register  to view this content.

Run this once to convert your existing case numbers.

Please Login or Register  to view this content.

No drawbacks I an think of unless you have to do math with the actual case numbers.