Display worksheet information on userform textbox Next & Previous buttons

Hello Again,

I am seeking help to searching textbox value until available possible.

I have searching option which is working fine and I need to continue search using next or previous button for same value match on a worksheet.

For Example:

I am searching for value "Dar Al" which is available 2 times on a worksheet for 2 different records but using search box it is displaying only very first record. I want to display these 2 records by using next or previous buttons.

Sample worksheet is attached for your reference.

Due to some error I am unable to upload a sample file. Please follow the link below.

GoogleDriveLink

Hi hecgroups,
check the attached file.
I marked the sign '****** rows that changed in the code.
Click several times on the "Search" button to see a few records.

Thanks for your response but I have to click for 2 to 3 times. Is their any solution for single click. Actually it will be better if I have Next or Previous buttons working to view the records.

If you enter "Dar Al" in the search box, then the macro will find Dar Al Shefa Hospital in B13, and then Dar Al Shefa Hospital in EP13 that are in the same row. Therefore you need to press 2 or 3 times to move to the next record. Because your macro looks for matches on an entire worksheet.

I am sorry some time user itself confused with large data. it is working by single click. I have last request. I should display a message saying that "Dar Al" or what ever a value is looking by a user is it reach till the last row means last data to avoid continually more search.

I hope you understand what is asking for...

try it

Please Login or Register  to view this content.

now I have a issue it is searching first record only not the rest.

It works for me. For example macro found 6 cells with an "Omar Al"

Thank you very much for your solution now I will study your script and try to implement it according to my boss requirement. Thanks for your efforts. Topic marked as solved and reputation is added.