.
Want the user to enter several different query terms in different fields (textboxes) and the autofilter macro return a match.
Currently have two similar macros that are not providing the desired results :
Macro #1:
Please Login or Register to view this content.
Macro #2:
Please Login or Register to view this content.
Please refer to additional description on Sheet 1 of workbook.
Thank you for reading and any assistance.
Try the attached file. I have removed all buttons except the "Search All Columns" button. I have added another text box in column D (TextBox3) so that the text boxes are sequentially numbered from 1 to 29. In your original file, TextBox3 was missing. You don't need to use it but it is necessary for the loop in the macro to work. Just type in the criteria in the desired box or boxes and click the button. I didn't do any comprehensive testing, but in the limited testing I did, it seemed to work properly.
You can say "THANK YOU" for help received by clicking the Star symbol at the bottom left of the helper's post.
Practice makes perfect. I'm very far from perfect so I'm still practising.
.
Thank you Mumps !! Impressive solution.
One of the previous resources I was attempting to utilize provided for entering a partial term for the query. Instead of "automatic" ... you could enter "auto" .. or "matic" .. or even a single letter .. "t" .
Is this possible with the solution you provided ?
I'm aware of using the asterisk "*" with autofilter but not aware if it is possible with this solution ? Or maybe LIKE ??
Try replacing this line of code:with this line:Please Login or Register to view this content.I entered "ll" (two L's without the quotes) in the first text box and it returned all the last names with a double "L". Also replacePlease Login or Register to view this content.withPlease Login or Register to view this content.This will leave the column headers after filtering.Please Login or Register to view this content.
.
Thank you Mumps.
A few quick tests and it appears to function well !
Appreciate your assistance.
My pleasure.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks