Hey,

sorry for my pore English.

Can anyone help me?

I want give a value in a textbox on sheet1 and search the value on sheet2.
then copy all de search results and paste as rows on sheet1.

when i replace this "Sheets("Gegevens Inbrengen").Textboxing.Value" in a fixt value like "7752" it copy's the rows from result of collum C

I also want to search range("A:J") for the value of the input textbox and not only one collum.

i have the following code:

Please Login or Register  to view this content.