+ Reply to Thread
Results 1 to 6 of 6

Loading data from one textbox to another in multipages.

  1. #1
    Registered User
    Join Date
    01-02-2017
    Location
    Amsterdam, Netherlands
    MS-Off Ver
    2013
    Posts
    6

    Loading data from one textbox to another in multipages.

    Hello,

    I was wondering if someone could help me with the following.

    I have a userform that includes a userform with a multipage with three pages on it.

    On the first page, the user fills in his address.

    The second page of the userform contains a billing address, and the third one a correspondence address, in case these are all different

    I want to make it so that after the user fills in his address on the first page, these details get loaded automatically in the billing address and correspondence address forms, unless the user

    changes the option from "same as main address" to "other".

    I am unable to load the data from textboxes on the first page of the multipage into the textboxes on the second page of the multipage.

    I have tried the following:

    Private Sub UpdatingofForm_Change()
    MultiPage1.Pages(0).textbox1.Value = MultiPage1.Pages(1).textbox2.Value
    End Sub

  2. #2
    Valued Forum Contributor kasan's Avatar
    Join Date
    07-22-2009
    Location
    Riga, Latvia
    MS-Off Ver
    Excel 2010
    Posts
    680

    Re: Loading data from one textbox to another in multipages.

    Why not just:
    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    01-02-2017
    Location
    Amsterdam, Netherlands
    MS-Off Ver
    2013
    Posts
    6

    Re: Loading data from one textbox to another in multipages.

    I tried that as well, but it doesn't work unfortunately ....

  4. #4
    Valued Forum Contributor kasan's Avatar
    Join Date
    07-22-2009
    Location
    Riga, Latvia
    MS-Off Ver
    Excel 2010
    Posts
    680

    Re: Loading data from one textbox to another in multipages.

    Can we look at your userform? Attach your file (without any data).
    Press Go Advanced and then Manage Attachment

  5. #5
    Registered User
    Join Date
    01-02-2017
    Location
    Amsterdam, Netherlands
    MS-Off Ver
    2013
    Posts
    6

    Re: Loading data from one textbox to another in multipages.

    I have attached the userform.

    Thank you for your time.
    Attached Files Attached Files

  6. #6
    Valued Forum Contributor kasan's Avatar
    Join Date
    07-22-2009
    Location
    Riga, Latvia
    MS-Off Ver
    Excel 2010
    Posts
    680

    Re: Loading data from one textbox to another in multipages.

    Your UserForm didn't display all elements on my machine, some kind a Frames loaded.
    I've created sample multipage form with two textboxes. When you type some text in Page1 - textbox in Page2 will contain the same info. But if you will change text in Page2 - text on Page1 will stay the same.
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Command Button on Multipages
    By cutelittleguy in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 12-15-2016, 10:34 AM
  2. Loading more than 255 characters into a userform textbox
    By witchcraftz in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 01-27-2016, 05:49 PM
  3. [SOLVED] Fill multipages
    By MADA BLACK in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-18-2015, 05:20 AM
  4. [SOLVED] Loading the value of text file (notepad) to a textbox
    By nathan0519 in forum Excel General
    Replies: 4
    Last Post: 07-17-2014, 10:48 PM
  5. Multipages on a form
    By samtwilliams in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-02-2007, 02:53 PM
  6. Dynamically Adding Multipages to Multipages
    By jwidhalm in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-17-2005, 04:23 PM
  7. [SOLVED] add a label to Multipages
    By OkieViking in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-16-2005, 04:06 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1