Multi-Column ComboBox

[nikolis69]

Working with Excel/VBA, I want to create a 2-column ComboBox which features e.g. the first name and the surname of actors. The source is an Excel worksheet, with the names in Column A and the surnames in Column B.
The contents transition from Excel to the userform ComboBox has worked out fine, selecting a row (of the ComboBox) is also fine, but when a ComboBox item is selected I only get to view the first name, not both names together.

Meaning when the ComboBox contents are all viewable as drop-down list and I toggle between the lines, each line is "fully selected" (meaning that both name & surname are "blue colored"). Yet when I actually click the mouse - and thus all I can see from the ComboBox is the selected actor/actress - only the first name appears. The surname still exists but is not viewable unless the full contents are dropped down again.

Any ideas why this is happening and how I can overcome it ?

Thank you in advance.

[torachan]

have a third column with columns 2 & 3 concatenated and make the new column the bound column so that it becomes the combobox value.
only one column can be the key column.

[nikolis69]

You mean 3rd ComboBox column is columns 1 & 2 concatenated ?
And the whole issue is, more or less, about the Bound Column property ... correct ?

[torachan]

yes, you can have a number of columns visible in the dropdown list, however the search is done on the bound column.

[nikolis69]

Thank you torachan !