I have designed a userform for gathering 16 data elements for entry to a
spreadsheet datalist.

I am not familiar with using arrays and would like to know how can I use an
array formula to retrieve the data from the userform and then add a new line
to the datalist and populate it with the array data.