Dynamic filter by numbers

Hi.
I'm new to vba and about the only thing I can do so far is to tweak copied codes.
Now i have a problem, a simple one.

Im trying to get a filter searchbox to work. I get it to work when "as string" using:

Please Login or Register  to view this content.

To the question: How do i change this code so that it works in another field that contains numbers(material numbers e.g. 78531649)?

To clarify, I understand that the "problem" is the string function and i have to change it to something else like "integer"

Hi and welcome to the forum,

At the moment the code is filtering the 3rd column in Table 1. Change the value 3 in the Field:= line to whichever column contains the material number

Originally Posted by martin.lasses

Hi and thx.
I have tried with only changing the field, but since field 3 is text and the field i now want to filter are numbers i think i have to change the dim from string to soemthing else, maybe integer?

First of all unless the table has been changed then you should be filtering something other than field 3. i.e. the material number field. I don't think it would make any difference if you left the variable as a string variable since the macro would treat the numbers in the columns as matching the criteria. However given that they are numbers it makes more sense to declare them as numbers. So something like

Please Login or Register  to view this content.

obviously change the Field ref to the Material Number column number in the table.

Hi,

Maybe it's time to upload the workbook so that we may check in context.

I have been trying. When i press the attachment Icon a small whitw window appears but no Browse function or anything. If i drag the file to the message box it starts to download the file...
Dont no what to do?

I have been reading the faq. i cant seem to find the way to post reply button, only get to quick reply.

Hi

You should be filtering on field 6, In addition just use
strfilter = [h1]

There seems little point using a text box just for that to fill a cell when you could enter directly to H1.