Textbox to search Worksheet

[nuttycow13]

Hi i am trying to get a text box to search a worksheet and read the information in that row and input it to other text boxes. at this time all i need to get working is to read the text box and search on the worksheet. so far i have:

Range("B1").Find(Columns("b")(Find_Printer.Text, , , xlWhole, , , True).Row, 1)(xlDown).Select

but this does not work at all.

I need to read column B for what is in Find_Printer text box.

If anyone could help me that would be great.

Thanks in advance.

 

[flipcube]

change Find_Printer.text to .value

 

[taurean]

Try something like:

Dim r As Range
Set r = Columns("B:B").Find(Find_Printer.Text, , , xlWhole, , , True)

This will set the found cell to variable r.