Combobox on a userform does not display the two columns

Hi friends, looking for help again.

I have written the following code to populate a two columns combobox on a Userform with data from a worksheet . The problem is that it only displays the second column (1), but if you select a row, the combobox text shows the first column data (0). I need:

1. Both columns to be displayed in the list to help user to make the right choice.

2. Combobox text displays the two columns of the selected row.


Any help will be highly appreciated.

Thank you so much.

necalabria

HTML Code: 

Thank you so much 6StribgJazzer.

Using an array is one method to populate a multicolumn combobox, yours is better. Therefore, I will use it.

Right, the columns widths are wrong . I did not realized they are too small.

Thanks again.

necalabria

Your welcome, I hope this helped.

There is nothing wrong in using an array, but in your situation I don't think it's an advantage. It's not faster and it makes the code more complicated. In some situations it might be a good choice.

Hi 6StringJazzer,

Regarding the combobox.text displaying the selected two columns data, I tricked a little with two simple codes

The first passed the columns data to the combobox.text and inserted " / " (ie: blank space-barslash-blank space) between them.

The second one ( partially shown), splits the string in combobox.text in two parts in order to get the referencce to look for the right worksheet row to work with it.

Thank you for your help and comments

Code N° 1

HTML Code: 

Code N° 2

HTML Code: