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

or

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

Outcomes