Home

Multi-select Listbox with descriptions

%3CLINGO-SUB%20id%3D%22lingo-sub-633507%22%20slang%3D%22en-US%22%3EMulti-select%20Listbox%20with%20descriptions%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-633507%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20spreadsheet%20which%20maintains%20a%20running%20log%20of%20training%20events%20in%20chronological%20order.%20Those%20events%20are%20tracked%20by%20a%2011-digit%20training%20code%20in%20the%20rightmost%20column.%20An%20event%20can%20have%20multiple%20codes%20associated%20with%20it%2C%20so%20I%20need%20the%20ability%20to%20select%20all%20of%20the%20codes%20that%20apply.%20I%20recently%20followed%20the%20instructions%20from%20%3CA%20href%3D%22http%3A%2F%2Fwww.vlsiip.com%2Fexceltips.html%22%20target%3D%22_self%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3EAviral%20Mittal's%20webpage%3C%2FA%3E%20on%20how%20to%20create%20a%20multi-select%20listbox%20using%20VBA.%20It%20pops%20up%20a%20listbox%20which%20contains%20all%20possible%20training%20codes%2C%20and%20when%20I%20select%20the%20ones%20that%20apply%20to%20that%20event%2C%20it%20populates%20them%20in%20the%20appropriate%20cell%20in%20the%20log.%20Next%20step%2C%20I%20would%20like%20to%20add%20a%20second%20column%20of%20text%20to%20the%20listbox%20which%20contains%20a%20description%20of%20the%20training%20code%2C%20however%20I%20do%20not%20want%20the%20description%20to%20populate%20in%20the%20target%20cell.%20I%20already%20have%20a%20named%20range%20which%20contains%20the%20descriptions%2C%20I%20just%20need%20to%20figure%20out%20how%20to%20enter%20them%20into%20the%20listbox.%20Any%20idea%20on%20how%20I%20can%20accomplish%20this%20in%20VBA%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-633507%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Charlie8002
Occasional Visitor

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?

Related Conversations
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
Early preview of Microsoft Edge group policies
Sean Lyndersay in Discussions on
65 Replies
*Updated 9/3* Syncing in Microsoft Edge Preview Channels
Elliot Kirk in Articles on
201 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
2 Replies