Hi. I'm using MATCH in my userform (phonebook): it goes like that: if you type person's full name (accurately!) then you get his/her full details, like his/her phone, email, etc. But what if users don't know the full name of the person they are looking for, say they only know last name, how do I use MATCH then? I guess there is a way to "soften" the search criteria?
Last edited by GIS2013; 08-29-2013 at 03:09 AM. Reason: typo
If you provide the same sample file then i can help you?
Regards
CA Mahaveer Somani
Hi GIS2013,
See if the suggestions and / or my code from this thread from just yesterday helps.
Regards,
Robert
____________________________________________
Please ensure you mark your thread as Solved once it is. Click here to see how
If this post helps, please don't forget to say thanks by clicking the star icon in the bottom left-hand corner of my post
@ Mahaveer, thanks. I'll upload sample soon.
@ Robert, thanks. I've read your code, and since I'm not (yet) a VBA expert, I'm rather hesitating to change the core of my code, the MATCH method, I saw that you've used FIND rather than MATCH, so any chance we can proceed with MATCH? Maybe I can "fine tuning" the function arguments?
The sample is attached. Please ignore any error that causes my search button to return actually blank textboxes2&3. The principle is that one types Jo, for example, and receives: Doe, [email protected] in textboxes2&3 accordingly
Hi guys, any further information is required?
As your file has a xlsx extension, it's macro free. There cannot be any forms on it
Yes, sorry for that. Now it's enclosed. So the two entries I've entered represent two problems:
a) I'd like the user to type jo and get john doe's details (company and email)
b) What the user would see if the name john is entered? There are two items with the same name..
ThankYou
Add a listbox to the userform, set it's ColumnCount to 3 and add this code to the userform module.
Please Login or Register to view this content.
If posting code please use code tags, see here.
Splendid NorieThank you!
Hi GIS2013,
Though Norie has provided a great solution, I've attached my following code to the user form on the attached workbook as well which also uses a listbox approach.
HTH
Robert
Please Login or Register to view this content.
Hi Robert. It's a great option, though I need one modification. The sample range is tiny A2:B3. But in real life it'd be much larger. So it might be tedious to find somebody called xavier (for the X). So what's the best way to keeping your very tightened code but at the same time replacing the listbox with a textbox?
Keep the listbox as it has scroll bars for large datasets. If you have the data sorted by name (you could build this in code before the form is opened) it's then no problem to scroll down and easily select (click on) the desired person.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks