How to add search on multiple

[Prabhahsini]

HI I managed myself up to adding a userform and add data to excel sheet with auto sequence on date time and serial number, I have attached,

Can I have help on how to put a search button for my userform, and search by Name or Phone or E mail or by all 3 on the userform and then filtered results comes in the same userform below (not on excel sheet)

Thank you

[Naveed Raza]

Based on that three option u want to search data right and that data should display on userform itself is it right ?

[Prabhahsini]

Based on that three option - want to search data - right and that data should display on userform itself is it right ? - Yes
But when multiple is there i am trying hard to do this example attached. to get FIND and Amend to my excel sheet content

[Naveed Raza]

Hmm that i will update

need one more clarificatin, u want to search contain in list or else exact match value ?

[Prabhahsini]

contain in list..

[Prabhahsini]

Thank you for helping me out

[Naveed Raza]

its lunch time post lunch i will provide

[Prabhahsini]

will wait .. mine too..

[Naveed Raza]

almost done....! need some more time

[Prabhahsini]

Thank you.. will wait till you revert...

[Naveed Raza]

Have test and let me know is it what your looking for

[Prabhahsini]

HI Tx, but I cant find the buttons in the excel sheet

[Naveed Raza]

HI Tx, but I cant find the buttons in the excel sheet

I have Edited that post #11 have test

[Prabhahsini]

HI sorry , cant understand.. i am searching for that "Open userform" "exit" buttons not there .. Where can I find them to call the userform pls

[Naveed Raza]

Now check this attached

[Prabhahsini]

HI sorry got it

[Prabhahsini]

HI did a test, it has a drop down to search by: then i put the name result says 1 record find so on.. but how can i see that record pls.. like the k234.xlsm‎ example

[Prabhahsini]

Instead of selecting the drop down, can i straight away type on each of the filed and then results be shown as the k234.xlsm‎ example ?

[Naveed Raza]

If you want in that way then u have to search record by anyone option from(name,phone,email) or else if you want to search somethime with all, sometime with any 2 option, sometime with only 1 option then code will become full lengthy.

[Naveed Raza]

HI did a test, it has a drop down to search by: then i put the name result says 1 record find so on.. but how can i see that record pls.. like the k234.xlsm‎ example

after search, just click on listbox record u will get all record information in userform it self

[Prabhahsini]

HI , checked.. actually that is the option i was looking for.. but i checked this one as well i get a runout error

run time error select method of range class failed

[Naveed Raza]

Hi Prabhahsini

Now have test this attached file, I completed made changes to this

Hope this will work perfect for you