Ozgrid Excel Help & Best Practices Forums

Excel Training / Excel Dashboards Reports

Results 1 to 2 of 2

Thread: connecting multiple userforms

  1. #1
    Join Date
    4th July 2004

    connecting multiple userforms

    I have set up a userform with a command button and a text box. when the command box is clicked it shows a second userform using userform2.show. The second userform also contains a comand button and text box. Is there a way to make it so that when the second userforms command button is clicked the data in its text box is entered into the text box in the first useform and the second userform unloads. thanks

    Excel Video Tutorials / Excel Dashboards Reports

  2. #2
    Join Date
    24th January 2003
    Hi tdsmith

    Private Sub CommandButton1_Click() 
        UserForm1.textbox1 = Me.textbox1 
        Unload Me 
    End Sub 
    Where CommandButton1 is on UserForm2.

Thread Information

Users Browsing this Thread

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

Possible Answers

  1. Hide / Show Multiple UserForms
    By martyaud in forum Excel General
    Replies: 3
    Last Post: February 12th, 2008, 07:11
  2. Alternative To Multiple UserForms
    By Karebac in forum Excel General
    Replies: 6
    Last Post: May 23rd, 2007, 16:23
  3. Multiple Active Userforms
    By GravityAB in forum Excel General
    Replies: 3
    Last Post: December 5th, 2005, 18:55
  4. Printing Multiple UserForms on One Page
    By russellgardham in forum Excel General
    Replies: 7
    Last Post: October 16th, 2005, 02:03


Posting Permissions

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