Loading
Ozgrid Excel Help & Best Practices Forums

Excel Video Tutorials / Excel Dashboards Reports



Results 1 to 2 of 2

Thread: connecting multiple userforms

  1. #1
    Join Date
    4th July 2004
    Posts
    25

    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
    Location
    Australia
    Posts
    31,697
    Hi tdsmith

    Try
    VB:
    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. UserForms with multiple monitors
    By BillV in forum Technical Issues Help
    Replies: 9
    Last Post: June 20th, 2013, 11:39
  2. Hide / Show Multiple UserForms
    By martyaud in forum EXCEL HELP
    Replies: 3
    Last Post: February 12th, 2008, 06:11
  3. Alternative To Multiple UserForms
    By Karebac in forum EXCEL HELP
    Replies: 6
    Last Post: May 23rd, 2007, 16:23
  4. Multiple Active Userforms
    By GravityAB in forum EXCEL HELP
    Replies: 3
    Last Post: December 5th, 2005, 17:55
  5. Printing Multiple UserForms on One Page
    By russellgardham in forum EXCEL HELP
    Replies: 7
    Last Post: October 16th, 2005, 02:03

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
  •  
porno