How do I handle dropdown buttons in VBA? Want current record to show the dropdown item

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.

Each item in the Combobox dropdown has an index number. The first item in the list is index number zero. This will select the first item in the Combobox. The same applies to the Listbox.

Please Login or Register  to view this content.

AlphaFrog,

I am able to load the current record in the dropdown list on my userform but what I also want is for all of the options for that dropdown to show up in the list if the user decides to change that current record. The options from the table should be displayed if they click on the dropdown arrow.
What would be the best way to make it work like that?

I am attaching what the dropdown looks like.
So I am pulling in the current record which is displayed in this dropdown.
But I want the user to be able to click on the dropdown(highlighted in yellow) and see the entire list of options so they can change it if they want to.
Right now if I click on the highlighted dropdown there's nothing to choose from.
What would be the best way to accomplish this?