"Robbyn" wrote in message
...
I'm using a multipage form - each page representing a different day of the
week(Day1 - Day5). Each page contains the same textboxes, comboboxes, and
checkboxes. Many times whatever the user inputs for Day 1, will work with
Day 2 or Day 3. I would like to simplify user input by duplicating
whatever
is inputted into Day 1 into the rest of the pages. The user then has the
option to change values as needed on the rest of the pages (days). Is
this
possible?

Hi Robbyn,

Another option you should look into when designing this type of UserForm
is the TabStrip control. This control allows you to display tabs just like
the MultiPage control, but rather than having a duplicate set of controls
for each tab, you use exactly the same controls for every tab. As the user
clicks different tabs, you trap the TabStrip_Change event and move data in
and out of the controls as appropriate for the current value of the selected
tab. Any array of a User-defined Type that has a member for each control
makes this a very simple operation.

--
Rob Bovey, Excel MVP
Application Professionals
http://www.appspro.com/

* Take your Excel development skills to the next level.
* Professional Excel Development
http://www.appspro.com/Books/Books.htm