Multipage forms

  • Thread starter Thread starter Topher
  • Start date Start date
T

Topher

Is it possible to have details entered on one page on a form display on
another. Example:

Page 1 - Enter Name Text Field
Page 2 - Above data displayed in a Test Field 'do you want to use this name?'
 
the names of the textboxes must be unique to the userform. so you cannot have
textbox1 on page1 and textbox12 on page2, you need to have textbox1 and then
textbox2.
So yes, on your page2 you could do this

Private Sub MultiPage1_Change()
Dim text As String
If MultiPage1.Value = 3 Then
text = TextBox1.text
If MsgBox("page2 text:" & text, vbYesNo, "Use this name") = vbYes Then
TextBox2.text = TextBox1.text
End If
End If
End Sub
 
Back
Top