Search and Cycle Through Matched (UserForm)

Hi, I am writing to request help in cycling through matched findings on a userform.

Several weeks ago, AlphaFrog kindly helped me in developing a code that helped me search an item through matched items in this forum. I have attached the workable code here.

I am now wanting to cycle through found items, where if there are more than 1 match found. I'm struggling to do this, any help would be appreciated.

Basically, the user has to input "unique ID" (Column C) and "date" (Column E). This should then return matched "Product Options" (column F), "Name of Company" (Column D) and "Price" (column I). The current code returns the first match. I would like the code to be expanded, so when I keep pressing "Search" on the userform, it will go to the next match, and so on.

Thanks in advance.

Hi, thanks for your response. I have tried to run it, but its not working, it comes with error. Firstly, when I put the unique ID and Date, next to Name of Product, it says "Showing 0 of 0 Matches".
Capture1.PNG


When I click on Next Match, it comes with error message "Run time Error '5' - Invalid Procedure call or Argument", points to Me.Company = ActiveSheet.Range("C4").Offset(iMatch(MatchNum) - 1, 1).value

Please Login or Register  to view this content.

It is working now. Thank you, this works brilliantly!