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?
