View Full Version : Solved: Search Form Help

05-23-2008, 05:34 AM
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.


05-23-2008, 06:39 AM
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.

05-23-2008, 07:52 AM
Works Perfect Thank You!

05-23-2008, 08:52 AM
Glad to help. Be sure to mark your thread solved using the thread tools at the top of the page.

05-23-2008, 11:42 AM
would it be hard to edit this to search an open but inactive workbook?