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 ?
Arr = rst.GetRows
i = 0
.ColumnHeads = False
.ColumnCount = rst.Fields.Count
.Column = Arr
.ListIndex = -1