Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 20
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1,298
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Multipage forms AJM1949 Excel Programming 2 July 30th 07 10:56 PM
User Forms Multipage Background/Foreground Colors Bryan44 Excel Programming 3 October 26th 06 03:32 AM
Multipage forms imported in XP DKS Excel Programming 12 September 22nd 06 11:58 PM
Calling Forms from Forms - Exit problems Stuart[_5_] Excel Programming 3 May 25th 04 06:50 AM
Multipage control on Excel VBA forms James Garner Excel Programming 2 December 4th 03 06:37 AM


All times are GMT +1. The time now is 03:17 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"