Hi everyone. I have a userform that has 200+ combo boxes and text fields.
(The form is a multipage - one tab of 40 fields, 12 pages for each month).

When I write the data from the form to the database (excel sheet), I am
currently doing it one field at a time. Is there an easier, more efficient
way to write block of data? Each tab of the form represents a month, and
each month will be on a seperate line in the datasheet.

Thanks!

basically, the computer will have to execute an individual write for each
control.

There is no method to write a block of data unless you loop through your
controls and populate an array, then write the array to the worksheet.

--
Regards,
Tom Ogilvy

"Steph" wrote in message
...
Hi everyone. I have a userform that has 200+ combo boxes and text fields.
(The form is a multipage - one tab of 40 fields, 12 pages for each month).

When I write the data from the form to the database (excel sheet), I am
currently doing it one field at a time. Is there an easier, more
efficient
way to write block of data? Each tab of the form represents a month, and
each month will be on a seperate line in the datasheet.

Thanks!