+ Reply to Thread
Results 1 to 6 of 6

Copy from value from Textbox to Combobox in another userform.

  1. #1
    Registered User
    Join Date
    11-01-2021
    Location
    Wisconsin, United States
    MS-Off Ver
    MS Office 365
    Posts
    8

    Copy from value from Textbox to Combobox in another userform.

    Hello,

    I'm trying to copy a value from textbox2 (UserForm2) to Combobox5 in Userform1 when clicking commandbutton1. I would also like userform2 to close after clicking the command button if possible?

    Please Login or Register  to view this content.
    Thanks,

  2. #2
    Forum Expert
    Join Date
    08-17-2007
    Location
    Poland
    Posts
    2,206

    Re: Copy from value from Textbox to Combobox in another userform.

    Probably
    Please Login or Register  to view this content.
    Artik

  3. #3
    Registered User
    Join Date
    11-01-2021
    Location
    Wisconsin, United States
    MS-Off Ver
    MS Office 365
    Posts
    8

    Re: Copy from value from Textbox to Combobox in another userform.

    I'm running into a compile error with the .ComboBox5 in the code.

  4. #4
    Forum Expert
    Join Date
    08-17-2007
    Location
    Poland
    Posts
    2,206

    Re: Copy from value from Textbox to Combobox in another userform.

    The compilation error says that you either do not have a UserForm named UserForm1, or that you do not have a control named Combobox5 in this form.

    Artik

  5. #5
    Registered User
    Join Date
    11-01-2021
    Location
    Wisconsin, United States
    MS-Off Ver
    MS Office 365
    Posts
    8

    Re: Copy from value from Textbox to Combobox in another userform.

    Okay, Figured it out thank you for your assistance. My next question tying to this is how to unselect the combobox5 in userform1 after the code has been executed? After running the code in userform1 if click any other object it'll make userform2 popup.
    Last edited by Isaacv22; 03-23-2022 at 09:36 AM.

  6. #6
    Forum Expert
    Join Date
    08-17-2007
    Location
    Poland
    Posts
    2,206

    Re: Copy from value from Textbox to Combobox in another userform.

    I am not a sorcerer. I also don't have a magic glass ball. Attach a file that will reflect your task.

    Artik

+ 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. [SOLVED] problem copy data from userform to sheet by multiple combobox & textbox
    By ABDELFATTA in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 09-12-2020, 07:55 AM
  2. [SOLVED] Userform copy textbox value to different range depending on Combobox selection
    By icsiszer in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 07-11-2018, 03:42 AM
  3. [SOLVED] Userform - Multiple Criterias (Textbox, Combobox) Return Value in textbox
    By givemeaccessexcel in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-02-2018, 09:25 PM
  4. Replies: 0
    Last Post: 08-18-2015, 04:13 PM
  5. input the value of a Combobox and a textbox to a TEXTBOX directly from a userform
    By Gordonhk in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-11-2013, 03:25 PM
  6. [SOLVED] Excel Userform: Populate other controls (i.e. textbox & combobox) based on combobox select
    By MileHigh_PhD in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 01-22-2013, 04:50 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