View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_6_] Bob Phillips[_6_] is offline
external usenet poster
 
Posts: 11,272
Default Duplicate Values on Multipage form

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)


"Robbyn" wrote in message
...
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