Macro to select next result that an xlookup would return

I am creating a UserForm that is pulling records of my customers from a worksheet to my UserForm using this code:

Please Login or Register  to view this content.

The data is then populating this form:

Screenshot 20SFDFSDFSE23-04-18 101459.png

This is fine, but my customers that I am looking up have multiple records, and I want a function that selects the next record down that falls into the XLookup criteria.

TLDR, i want to press a button that shows the next thing down a list that my xlookup would be returning.

Originally Posted by Dylan1023

I want a function that selects the next record down that falls into the XLookup criteria.

I am not clear on what you mean by this. Do you mean that searching for SalesForm.BHSDMAINNUMBERLF.Value there is more than one match in Range("E:E") and you want to return the second match instead of the first?

If so, your code must be entirely rewritten. I would use the Find method to find the first, then FindNext to find the second. I would do this by having factoring out this functionality into one Sub that your others subs would call. For example:

Please Login or Register  to view this content.

Untested because file not provided.

Hello.
It seems to me that you are "complicating life" unnecessarily.

I suggest you upload a short workbook (no more than 10 records) and your macros to the Forum so we can show you better ways to manage your information.