Get data from ListBox on MultiPage

Are you able to post your workbook?
I'm not sure why Function Selected_ListTracker is in a module and not the userform?

Posting it right now would need sanitising a load of stuff. I understand why you're asking though...



This is what the first page looks like. On the second page is a further control.

When the user clicks the Edit button the control boxes you can see are populated with data from the selected record in the ListBox. It works for the page you can see, but I can't get the data from the ListBox on the next page (Page = 1) to populate the controls there. The code posed above works for the controls on the page you can see.

I'm assuming it's something to do with referencing the MultiPage Page reference, but I'm not sure, as I can populate the ListBox on the other page simply by referring to it, e.g. lstName.

I used the code from an online tutorial and in it they placed the Function Selected_ListTracker code in a Module? Outside of that I'm not sure why they did it that way, sorry.

Is this any help?

Sorry, so a copy of the workbook is attached.

What I'd like to achieve is that when the user selects a record in the listbox it populates the corresponding controls on the page. I'd like that to be the case on the listbox on page 2 as well, so the control is populated with the data from the record selected in the listbox on page 1.

Thank you MikeVol, that is exactly what I needed.

Can I ask another question? It is related but let me know if it needs a new post.

Can the record of the second ListBox be displayed based on the selection in the first?

For example, the user selects a record in a ListBox and the appropriate controls are populated. Can this selection determine the selection in a separate ListBox? Even if that ListBox is loaded via a separate UserForm, via a CommandButton?

Thank you again.