AnsweredAssumed Answered

General VBA Question - ListBox and Arrays

Question asked by Cad Admin on Feb 25, 2019
Latest reply on Feb 25, 2019 by Frederick Law

This is a more General VBA question.


I have a listbox that is pre-populated with 1 row. (this row is NOT part of the array.)

I need to add the values from an array to the listbox

I know UserForm1.ListBox1.List = myArray will populate the listbox fine, however it removed the 1st row that is already populated.


Is there a way to retain or redim the fist row, and insert the array after


would it be possible/better to re-read out the listbox's 1st row to the array and re-populate.