SELECTING A SINGLE ITEM IN A MULTICOLUMN COMBOBOX

[chazrab]

As the title addresses, is there any way to select any single item in a multicolumn combobox by clicking on that item?
Image below. Example: Clicking on Matthew, Romans, Revelation, etc., populates the combobox with that value.

As we know, clicking on any item does not recognize that item, but selects that whole row the item is on. Not what I want.

If not, is there a way to emulate a combobox action that would achieve this result? Each
item would have to be taken as individual objects(put in separate textboxes) or something like that

Any help would be greatly appreciated.

Thanks, cr

 

[Micron]

In Access you can refer to the .Column() by its position from left to right in the list and the column index is zero based. So if you want the value from the 2nd column it would be [parent object].Combobox1.Column(1). I imagine it's the same in Excel.
Not sure if that's what you're after.