Pass an array collected from textboxes to a multicolumn listbox as an next entry

Have you tried Column property instead of List?
i.e

Please Login or Register  to view this content.

Hi Jindon, no go I'm afraid, just succeeds in clearing previous entries in the listbox

Then try change the array with .Value property

Please Login or Register  to view this content.

Thanks Jindon, that now writes to the listbox. Strange as the data could be viewed in Debug.Print. It overwrites the items in the listbox though can it be be directed to become either the first or subsequent entry in the listbox

Hi Jindon
Faults on

Please Login or Register  to view this content.

.List = Could not get the list property invalid argument
.ListCount = 1
i = 0

Yep, that I realized and edited the previous code, ListCount -1

Please Login or Register  to view this content.

Hi Jindon just saw that. Many thanks for your kind assistance. I will mark as solved

Have a great Christmas

You are welcome and thanks for the rep.

Same to you...