Excel VBA, Populating ListBox

Hello,

I have a UserForm "CustomerLookupUserForm". On MultiPage Page "Page5", I have a ListBox "SDCustomerList" and five OptionButtons: "SDCentral", "SDEast","SDWest", "SDTradePartners", and "SDWholesale". Each OptionButton represents a region of the company using the application.

I have the data I would like to load into the ListBox "SDCustomerList" in a two-column Table "NamesListTable" on Sheet "Administration". Column A is Customer Name and Column B is Region.

How would I accomplish the following?

I would like to load all Customers in the Customer Name column from the Table "NamesListTable" into ListBox "SDCustomerList" when the UserForm "CustomerLookupUserForm" is loaded/activated. However, I need to be able to select an OptionButton (which represents a Region), e.g. OptionButton "SDCentral", and it filter the ListBox to only show Customer Names where the Region is "SDCentral" in the aforementioned Table "NamesListTable".

Any help is greatly appreciated.

Hi EnigmaMatter

A copy of your Workbook would be helpful...

(Attribution to Leith Roth)
To help you with this problem, you need to post your workbook.

This allows solutions to be tested using your code and not on code recreated based on your post.
If your workbook contains any sensitive information, please redact that information before you post.

How To Post Your Workbook

• At the bottom right of the Reply window, Click the button Go Advanced
• At the top of the Your Message Window, in the first row of icons, Click the Paperclip icon.
• Click the Add Files button at the top right in the dialog box. This displays the File Manager dialog.
• Click the Select Files button at the bottom middle of the dialog.
• In the new window Find the file you want to upload, select it, and Click Open.
• You will now be back in the File Manager dialog. Click the bottom Middle button Upload File

.
Wait until the file has completely uploaded before you exit the File Manager dialog.

I was able to figure it out by loading it from the first column, and then filtering based on the value to the right.