<div>
I think it is unwise to assume that if nothing is selected, everything should be processed. &nbsp;For listboxes with many items, I usually add two buttons, one for selecting everything and one for deselecting everything. &nbsp;This is safer. &nbsp;Here is the code for selecting all -- for deselecting, change True to False:<br />
<br />

<pre><code id="code-20-39249273-1">Set lst = Me![lstSelectMultiple]
intRows = lst.ListCount - 1

For intIndex = 0 To intRows
   lst.Selected(intIndex) = True
Next intIndex</code></pre>
</div>


I think it is unwise to assume that if nothing is selected, everything should be processed.  For listboxes with many items, I usually add two buttons, one for selecting everything and one for deselecting everything.  This is safer.  Here is the code for selecting all -- for deselecting, change True to False:



Set lst = Me![lstSelectMultiple]
intRows = lst.ListCount - 1

For intIndex = 0 To intRows
   lst.Selected(intIndex) = True
Next intIndex

<div>
<div class="content wysiwyg-content">
I would like to be able to select multiple items from a listbox and then act on that selection list. Each item selected would initiate separate processing later in my code. I don't do alot with forms and am having trouble finding a good example of that. <br />
<br />
Flow:<br />
1. Select multiple items form the list box.<br />
2. If none is selected then assume all items in the box are to be used<br />
3. Read each item to a separate variable and initiate code later on in the script based on the variable.<br />
<br />
I imagine that I could read the listbox multiple times for to init the subsequent steps which just consists mainly of importing various data files.
</div>
</div>


I would like to be able to select multiple items from a listbox and then act on that selection list. Each item selected would initiate separate processing later in my code. I don't do alot with forms and am having trouble finding a good example of that. 

Flow:
1. Select multiple items form the list box.
2. If none is selected then assume all items in the box are to be used
3. Read each item to a separate variable and initiate code later on in the script based on the variable.

I imagine that I could read the listbox multiple times for to init the subsequent steps which just consists mainly of importing various data files.

Selecting multiple items from a listbox

Microsoft applications include a variety of software programs, including development and digital authoring programs (Expression and Media Center), educational programs, Internet software, including Essentials, Skype and the Live family, anti-virus, productivity applications and suites like Office, Excel, Word, Outlook, Access and PowerPoint, video games and server applications such as Exchange, SharePoint, IIS and Virtual Server.

Microsoft Applications

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.