Userform Question
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! |
Userform Question
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! |
All times are GMT +1. The time now is 08:31 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com