Solved: Display all visible columns in multi-column drop box selection?

[Dr.K]

I've got a UserForm with a bunch of drop boxes. They are ComboBoxes with the Style set to "DropDownList".

The main drop box contains 2 Columns. (actually, it contains 12 Columns, but only the first two are visible)

When you click on the arrow and the box drops down, you can see all of the columns. However, once you select something, only the Bound Column is visble. I would like BOTH Columns to be visible at the same time. Is this possible?

I've fooled around with all the settings and I can't get this to work. Hopefully I'm missing something obvious.


http://img149.imageshack.us/img149/6189/screendumpjt6.jpg


I suppose I could concatenate the two columns into one column, but then I'd lose the tab stop for start of the second column.

[mikerickson]

One option would be to add a thirteenth column, which holds the cocatenation of the first two and set .TextColumn = 13.

[Dr.K]

Yup, looks like concatenation is my only solution.

I figured out a neat work around for keeping the columns lined up: just stick a vbTab in between! Works great.

.List(x, 0) = rstA!ChangeDate & vbTab & rstA!ChangeBy