VBA Combo Box Display of selected item

[Giordano Bruno]

I have a Combo Box which lists three columns. It's actually 8 columns, but the middle five are set to width zero in the combo box. When I select an item, the display window shows only the value in the left hand column. This column is sometimes blank and so if I select one of these rows, the selection window shows nothing at all.

Is it possible to display more than just the first column or am I wasting my time trying?

 

[Giordano Bruno]

Hi Norrie,

Thanks for your observations. I really appreciate it. I don't use combo boxes that much. I was just experimenting today to shoe-horn my data into one.

I'm intrigued by your comment that I shouldn't use RowSource. I thought that was what it was for. I don't want to populate it via a loop at there are too many rows. Can you tell me what other method I should use.

I tried various tricks to populate the combo box with noncontiguous ranges, but they all failed. I would be very pleased to hear how it should be done.