I have a spreadsheet which maintains a running log of training events in chronological order. Those events are tracked by a 11-digit training code in the rightmost column. An event can have multiple codes associated with it, so I need the ability to select all of the codes that apply. I recently followed the instructions from Aviral Mittal's webpage on how to create a multi-select listbox using VBA. It pops up a listbox which contains all possible training codes, and when I select the ones that apply to that event, it populates them in the appropriate cell in the log. Next step, I would like to add a second column of text to the listbox which contains a description of the training code, however I do not want the description to populate in the target cell. I already have a named range which contains the descriptions, I just need to figure out how to enter them into the listbox. Any idea on how I can accomplish this in VBA?

I'm posting a "cleaned up" copy of the workbook in question. When I click on a cell in the "Logbook" sheet, I want it to pop up a listbox with the choices populated from the "CODES" and "DETAILS" column on the "Codes" worksheet. Right now it only shows "CODES". However, when I select an item or items, I only want the target cell to show the value from the "CODES" column.

Attached Files

Sanitized Logbook.xlsm (43.1 KB, 10 views)