Two column ComboBox Add from Named Ranges

I have a "Navigation UserForm on a project for 3 teams. I currently am using a single column ComboBox filing from a named range. It's used to set folders for saving reports generated by my main spreadsheet. Originally I was using the Supervisor-TeamLead as the name of the folder and the values in the range for the combobox. But with promotions/terminations...etc. That would not be wise. So what I want to do is use a second range, or even an array, to assign the value of 1, 2, 3 to the second column. Then store that in the string, based on user picking their "team." Currently the code I am using to load for the single column Combobox is as follows.

Please Login or Register  to view this content.

So For example if the combobox has Bob's Team, Tom's Team, Jane's Team in column 1, then Column 2 would contain 1, 2, 3. If I selected Tom's Team from the list, then I want my variable CTRteam to = 2.

Thanks in advance.

Hard to guess,,,
Try something like

Please Login or Register  to view this content.

Sending from phone.

I also found this option....would it do the same?

Please Login or Register  to view this content.

Also what is the easiest way to load the 1,2,3 in the second column? I know I need to use the .list option, but not 100% getting "how." lol

You mean row serial number?

Basically I have a Range on a hidden look-up worksheet. So Column looks like below.

Bob
Tom
Jane

Right now my code works fine to load those names into the combobox and pull the value using the code I've posted.
I think the code I found will return the value of the 2nd column. So part two, getting the value, is solved. Part one, putting the value of 1, 2, 3 in that second column is where I am stuck.
I want to either just auto added it via the VBA, or pull it from a second "range" on the look-up worksheet. Such as below.

Bob 1
Tom 2
Jane 3

Then add serial number next to the named range and use the code I first posted.

Alternative, using Table ?

ok, TY, I will try that. To confirm I'm understanding the code you posted correctly. The "Resize(, 2).Value" is going pull both columns in my "range" and add them to column 0,1 of the Combobox "list." Is that correct? Also do I need to expand the Named Range to both columns or does that code not care about the boundaries of the Range?

It doesn't matter as long as 2 columns are next to each other.

TY works like a charm. Solves so many issues on my end. Again TY TY TY lol

You are welcome.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.