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
Last edited by KennyJ; 05-23-2008 at 06:36 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.
Steve
"Nearly all men can stand adversity, but if you want to test a man's character, give him power."
-Abraham Lincoln
Works Perfect Thank You!
Glad to help. Be sure to mark your thread solved using the thread tools at the top of the page.
Steve
"Nearly all men can stand adversity, but if you want to test a man's character, give him power."
-Abraham Lincoln
would it be hard to edit this to search an open but inactive workbook?
Posting Permissions
Reply With Quote
