Solved: Search Form Help

[KennyJ]

I'm need to make a form with 1 button and 2 text boxes. I'm looking for the form to do a search when i click button1 on a range D2 to D2805 for the value I put in TextBox1. and i need it to output the value from columnA in the same row it finds the value from textbox1 in Textbox2. does this make any sense? I have had very little luck doing this as im very new to VBA. any help would be great.

thanks

[lucas]

Kenny, I just had a minute to look at your question but I have attached an example that will get you started. It has a listbox which will list all entries in column D and a search textbox that will allow you to start typing and will return the results in textbox 2 marked results.....hope this helps.

[KennyJ]

Works Perfect Thank You!

[lucas]

Glad to help. Be sure to mark your thread solved using the thread tools at the top of the page.

[KennyJ]

would it be hard to edit this to search an open but inactive workbook?