Duplicate Values on Multipage form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Good morning,

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?

Robbyn
 
Robbyn,

Should be. Just copy across as entered, something like

Private Sub TextBox1_Change()
With Me.MultiPage1
.Pages(1).TextBox2.Text = TextBox1.Text
.Pages(2).TextBox3.Text = TextBox1.Text
End With
End Sub


--

HTH

RP
(remove nothere from the email address if mailing direct)
 
Thanks again Bob. A simple solution to what I thought was a difficult
problem.
Hope you have a Happy Easter!
 
Robbyn said:
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?
Click to expand...

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
 
Back
Top