VBA to filter a table using a TextBox

[randall78]

Hi,
I am trying to use a TextBox to filter a table column.
The code below is working fine on a column that just contains text, however i also have a column who's cells contain a formula that returns the value so the filter doesn't work because the cell has a formula in it not a value. Any ideas. Here is the code i am using.

Please Login or Register  to view this content.

Here is the Table

Capture.JPG

[AlphaFrog]

What TextBox?
J3 seems like a cell reference.

You are using the * wildcard in the autofilter criteria which works on a column of text and not numbers. So for example if the filtered column is numbers, you cannot filter for a number that contains the digits 25. You could filter for greater than or less than 25 but not contains the digits 25.

A workaround could be to have another column that converts the numeric data to text using the TEXT() function. Then you could filter that text column for entries that contain the two digits 25.

[theclockmaker]

I suspect you need to select a Range, for my examples I'm using columns A through Z, you could specify whatever you need.

I created a table with text and numbers, and I filtered on 12 and 56, and it filtered them both for column A (field 1):

Please Login or Register  to view this content.

I also removed the equal signs within the search criteria and the code worked again just fine:

Please Login or Register  to view this content.

If you are searching for just a single filter then this works:

Please Login or Register  to view this content.