How to make a two column combobox that uses a range of values

[awpullen]

Currently, I have some perfectly working functionality that does the following:

A userform is launched from a command button on one of my worksheets.
This userform called "Project_Selector", has two comboboxes and a button on it. What it does is when you open the first combobox it presents a static list of values "Active" and "Inactive" (these are hard coded in the code). When you choose one of these values it does a lookup (contained in a loop and Case statement) on a column in one of two worksheets. It looks for and returns all the values in that column and populates the second combobox with them.

Basically it acts as a two stage filter and allows you to find an entry and then act on it by clicking the button.

My problem is that the list of values that get populated in the second combobox is a column that only contains project codes, and I would like for it to have two columns, one which has the code and the other that contains the contents of a different column in the worksheet that they are being retreived from, that is more descriptive and can help the use choose.

Does anyone have any thoughts on how to accomplish this?

Here is my code:

Please Login or Register  to view this content.

[Norie]

Have you considered using a multicolumn listbox instead of the second combobox?

[awpullen]

I have seen that a listbox could be used, but am not sure how to integrate it into the code above. Sorry, I am fairly new to VBA.

[awpullen]

Norie - Thanks, after investigating I got the listbox to work. A much better solution in every way.