View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Steph[_3_] Steph[_3_] is offline
external usenet poster
 
Posts: 312
Default 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!