hello, i have made a userform where i have placed a textbox, a listbox and a command button. my data has duplicates too. how can i search something i typed in textbox which would be a name or contact no or email address and it should show in listbox with all columns in a row without duplicates? can someone help me?
i have uploaded a excel file too.
Not sure about your definition of "unique" though.
Please Login or Register to view this content.
It's actually working with your code. i am able to search data without duplicates. thanks a lot. just want to ask you can we search some specific columns with this code like if we want to search data from range b2: h then what should we do? its for just knowledge.
You can use multiple text boxes to narrow down your search
Please Login or Register to view this content.
Last edited by mehmetcik; 11-04-2017 at 08:03 PM.
My General Rules if you want my help. Not aimed at any person in particular:
1. Please Make Requests not demands, none of us get paid here.
2. Check back on your post regularly. I will not return to a post after 4 days.
If it is not important to you then it definitely is not important to me.
Change
toPlease Login or Register to view this content.
Please Login or Register to view this content.
i will upvote you and i admire your given time to my question but unfortunatly my excel got crashed when i input something on your 2nd textbox and 3rd textbox.am i doing something wrong?
respected jindon sir, in both cases your code is doing great job, i will follow your other posted replies too learn more. i know you guys got nothing but you guys help and solve others problem and its really helpful for everyone.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks