Dear Specialist, Attached the excel file for your reference. with useform. I want to search via roll on codes (length of roll on codes are fix with 8 digest), If I put 4 digest in text box of roll on codes and hit the search button after this other text box suppose to be populate where the value matched with text box value. Even need to view previous and next value matched by hitting previous button and next button For example :- I enter roll on codes in text box i.e. 123456 and hit the search button then it need to show first code in text box of roll on code which is 12345678, then name Rabbit, Duty in 10% units Y
If hit the next button then it need to show next match value, and if hit the next button the need to show next matched value, and if hit the previous button then need to show previous match value. Roll On Code Name duty in % Unit's 12345679 Hourse 2% N 12345610 Lion 0% N 12345611 Tiger 0% N 12345678 Rabbit 10% Y Please help thanks in advance. Attached the excel file for your reference. -- Thanks & Regards, Prajakt Pande +971551388482 ** -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. ------------------------------------------------------------------------------------------------------ To post to this group, send email to excel-macros@googlegroups.com
ROLL ON CODES.xlsm
Description: application/vnd.ms-excel.sheet.macroenabled.12
