Populate Listbox - 1 row with 5 columns from values of 5 textboxes

I've spent some time doing searches and reading forums/documentation, but I am just stuck here.

I have a userform with 5 textboxes, a command button, and a listbox. When the user enters values into all 5 textboxes and then clicks the command button, I want those 5 values to be loaded into the listbox in one row, with 5 separate columns. Then the textboxes will clear, allowing the user to enter 5 more values, click the command button again, and add those 5 values to another row across 5 columns.

Whenever the user is finished adding data sets into the listbox and clicks a second command button, I will need to get all that data out of the listbox, into a 2d array.

Why not transfer the data to a sheet then load back to an array that repopulates the listbox.
To input data, first 'CLEAR' the form - this ensure an empty form and activates the 'ADD' button - enter your data to the textboxes and press 'ADD' this updates the sheet, the array and listbox.
Example as per the attached file.

As per Torachan...I'm also for the sheet entry processing...
TextBox entries go directly to sheet and is immediately stored into array...
Available to populate Listbox from said array...

So no need for...

clicks a second command button, I will need to get all that data out of the listbox, into a 2d array.

Please Login or Register  to view this content.