<div>
Unless someone comes up with a better solution you can use a loop to add individual items of the second list using the command<br />
<br />
frmResultAll.ListBox1.add individualitem
</div>


Unless someone comes up with a better solution you can use a loop to add individual items of the second list using the command

frmResultAll.ListBox1.add individualitem

<div>
You're welcome.<br />
<br />
I presume the suggestion resolved your issue.
</div>


You're welcome.

I presume the suggestion resolved your issue.

<div>
<div class="content wysiwyg-content">
excel 2010 vba<br />
<br />
I have listbox i'm populating from a recordset.<br />
<br />
I would like to also add additional items to the listbox via another recordset.<br />
<br />
<br />
Is this possible ?<br />
<br />
do i just need to use the same code as below to add items from the other recordset and it will add without deleting the items i have already in the litsbox ?<br />
<br />
<br />

<pre><code id="code-10-28252799-1">         Arr = rst.GetRows
       rst.MoveFirst
i = 0

With frmResultAll.ListBox1
   .Clear
        .ColumnHeads = False
        .ColumnCount = rst.Fields.Count
        .Column = Arr
        .ListIndex = -1
End With</code></pre>
<br />
<br />
Thanks<br />
fordraiders
</div>
</div>


excel 2010 vba

I have listbox i'm populating from a recordset.

I would like to also add additional items to the listbox via another recordset.


Is this possible ?

do i just need to use the same code as below to add items from the other recordset and it will add without deleting the items i have already in the litsbox ?


(CODE)


Thanks
fordraiders

adding additional recordset to listbox

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.