+ Reply to Thread
Results 1 to 6 of 6

Fill a cell via textbox on userform depending on combobox selection

  1. #1
    Registered User
    Join Date
    11-13-2012
    Location
    Lisburn
    MS-Off Ver
    Excel 2007
    Posts
    4

    Fill a cell via textbox on userform depending on combobox selection

    Hi,

    Basically I have a userform with 1 combobox and 1 textbox. (The combo box is populated with a dynamic range). I would like to be able to select an option from the combobox and when I click the command button the info in the textbox will be placed into the sheet in the same row as the selected combobox word. For example. The combo box has a list of names, I want to select a name, enter info into the textbox, click submit and have the info placed into a cell on the same row as the name. (The cell is 9 columns away from the name cell)

    Any help would be appreciated
    TIA

  2. #2
    Valued Forum Contributor
    Join Date
    11-02-2012
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003, 2007, 2010
    Posts
    564

    Re: Fill a cell via textbox on userform depending on combobox selection

    Attaching your workbook will be helpful.
    You can write code for click combo box event. Something like Range("XX").Value = Textbox.Value

  3. #3
    Registered User
    Join Date
    11-13-2012
    Location
    Lisburn
    MS-Off Ver
    Excel 2007
    Posts
    4

    Re: Fill a cell via textbox on userform depending on combobox selection

    Book1-2.xls

    Hi,

    I have attached the file, If you go to VB you will see userform "Evaluation wk 1" I basically need the combobox to select from range"projects" and when completed find the name of the project in sheet"Projects" and put the textbox info into the "evaluation wk1 cell according to project. I hope you understand this lol, it can be confusing when your not on my train of thought.

    Thanks again

  4. #4
    Valued Forum Contributor
    Join Date
    11-02-2012
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003, 2007, 2010
    Posts
    564

    Re: Fill a cell via textbox on userform depending on combobox selection

    Attached will help
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    11-13-2012
    Location
    Lisburn
    MS-Off Ver
    Excel 2007
    Posts
    4

    Re: Fill a cell via textbox on userform depending on combobox selection

    Hi Haripopuri,

    That's fantastic! Thank you very much for your help, really appreciated.

    Workbook complete!

  6. #6
    Valued Forum Contributor
    Join Date
    11-02-2012
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003, 2007, 2010
    Posts
    564

    Re: Fill a cell via textbox on userform depending on combobox selection

    Glad I could help

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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