ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Multipage forms (https://www.excelbanter.com/excel-programming/435725-multipage-forms.html)

Topher

Multipage forms
 
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?'



Patrick Molloy[_2_]

Multipage forms
 
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

"Topher" wrote:

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?'




All times are GMT +1. The time now is 10:03 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com