|
-
Nov 10th, 2014, 04:43 PM
#1
Thread Starter
Lively Member
Excel VBA Multiple Selection Listbox
I'm using the Form Control List Box via the Developer Tab and I'm trying to figure out a code to take my selections (multiple selection list box) and display them in a single cell with the selections separated by a comma.
When I right click the list box and navigate to the "Format Control" option, I get the option to make the list box a multi-select list box. 
However the selections default to "0" and I cannot figure out how to get the selections to display into cell G9 as follows:
"SelectionItem1, SelectionItem2, SelectionItem5, SelectionItem7..." [based on selections; into a single cell]
Tags for this Thread
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|