VB and VBA Users Source Code: Re: Return the selected contents of a multiselect list box

VB/VBA Source Code
Re: Return the selected contents of a multiselect list box

By:	Andy Foster
Email (spam proof):	Email the originator of this post
Date:	Monday, December 31, 2001
Hits:	678
Category:	Windows API

Article:
How do you get the selected items into the spreadsheet? I have a source array that is 15 columns by about 2000 rows--No problem getting that into the listbox, including the 4 columns that are needed to be visible for making the correct selection(s) based on city and season of the year. From the listbox, without using the active cell routine, how do I get the multiple selections onto another sheet (RESULT)? Ideally, I want to just capture the index numbers and via code run a variety of lookups on the source cells to return values for some and the formula for others and to create some new columns which act on the selected info. The result would be 10 columns and a row for each selection and start in A2. In that vein, I wanted 2 command buttons, one to "Update" by counting used cells in the RESULT sheet and adding new results in the first available row, while the "Ok" button would clear and fill the RESULT sheet. Thanks and season's greetings Andy
Terms and Conditions
Support this site Download a trial version of the Excel Workbook Rebuilder