My idea was on clicking the Submit button to loop through the userform
textbox's and collect the data into a single array.
Locate the last record, use offset to move to the next row.
Insert the user  input from the array


I like to make these routines as generic as possible, so would like to
additionally think of combo boxes, list boxes and option groups that I
may add  to the userform  at a later stage, but that is utopia. Just
dealing with plain textboxes at the moment, but if anybody has ideas I
would really appreciate them