I have created data tables within my spreadsheet and I have created dropdowns in my multipage userform and I have linked those data tables to the dropdown via the RowSource property.
I also have set up the initialize userform to load the first row of data in the worksheet so I want the current record to show the respective dropdown item of that record.
I want the user to be able to pick a dropdown item should they want to change the current data.
How do I properly show the current data record dropdown item but still have the table list that allows the user to pick another dropdown if needed?
I also have a listbox set up similarly. The user has the ability to select multiple items on the list but I also want the current record to show the listed items.
How do I properly set this up for listboxes also?
I think what I'm really asking for is to show the selected dropdown item and selected list box items when looking at the current record.