Display two columns in combobox

[fabian_76]

I have the following code that shows in combobox "cboCust" the information of ColumnB, how can I modify the code to show in combobox ColumnB and C?

Please Login or Register  to view this content.

[AlphaFrog]

Please Login or Register  to view this content.

[fabian_76]

That worked great thank you so much!

[fabian_76]

AlphaFrog, can you please help me to adjust the code if I want to select non-adjacent columns such as B, M and T?

[jolivanes]

One way would be to set the ColumnCount to 19 (Column B to Column T) and set the ColumnWidths for the Columns not needed to 0.

Please Login or Register  to view this content.

Or you can copy the needed Columns into another Sheet (Hidden or VeryHidden?) and use that.

[fabian_76]

thank you that worked