Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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?' |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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?' |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Multipage forms | Excel Programming | |||
User Forms Multipage Background/Foreground Colors | Excel Programming | |||
Multipage forms imported in XP | Excel Programming | |||
Calling Forms from Forms - Exit problems | Excel Programming | |||
Multipage control on Excel VBA forms | Excel Programming |