Userform to search worksheet and display data back to the userform

Hi all,

Back in this thread Leith created a wonderful way to search a worksheet and display the results in a list view on the userform.

To get results from the search, one must have the exact term from the worksheet. What would have to be changed in the code for partial matches to show? As an example, currently I would have to type 118.565 to see all results containing 118.565. I would like to only have to search 18.56 to see any results that contain 18.56.

Thanks in advance,

Zip

Edit: I am using version 1b

In the code, change "xlWhole" to "xlPart"

It's in this part:

Please Login or Register  to view this content.