+ Reply to Thread
Results 1 to 6 of 6

Populate Text Boxes based on Combo Box Selection

  1. #1
    Registered User
    Join Date
    04-01-2012
    Location
    Texas
    MS-Off Ver
    Excel 2010
    Posts
    4

    Populate Text Boxes based on Combo Box Selection

    I want to be able to populate text boxes on a user form based on the selection made in the combo box. The code I have works with one exception. If the first item in the combo box is chosen, all the text boxes populate with the information from column D (so all the text boxes have the same information in them). All the other combo box selections fill the appropriate text boxes correctly. I'm not sure where I've gone wrong. Any help would be appreciated. Thanks.

    Please Login or Register  to view this content.
    Last edited by Sasha28; 04-14-2012 at 06:31 PM. Reason: trying to add code tags

  2. #2
    Forum Expert Palmetto's Avatar
    Join Date
    04-04-2007
    Location
    South Eastern, USA
    MS-Off Ver
    XP, 2007, 2010
    Posts
    3,978

    Re: Populate Text Boxes based on Combo Box Selection

    Per forum rules, please edit your post to add code tags.
    Palmetto

    Do you know . . . ?

    You can leave feedback and add to the reputation of all who contributed a helpful response to your solution by clicking the star icon located at the left in one of their post in this thread.

  3. #3
    Forum Contributor
    Join Date
    09-10-2010
    Location
    Sanford, FL
    MS-Off Ver
    Excel 2016 Office 365
    Posts
    105

    Re: Populate Text Boxes based on Combo Box Selection

    Sasha,
    I did the same thing with the code tags- the way to edit your post is place
    Please Login or Register  to view this content.
    at the end. That should make it work. I am not one of the guru's but I am looking at your code to see if I can help there as well.
    Juli

  4. #4
    Forum Contributor
    Join Date
    09-10-2010
    Location
    Sanford, FL
    MS-Off Ver
    Excel 2016 Office 365
    Posts
    105

    Smile Re: Populate Text Boxes based on Combo Box Selection

    Whoops- that didnt appear right--
    [ use this bracket where it says bracket and the actual typed word code where it says code
    bracketcodebracket your code in the middle bracketforward slashcodebracket
    Last edited by Juli; 04-13-2012 at 10:08 PM.

  5. #5
    Valued Forum Contributor john55's Avatar
    Join Date
    10-23-2010
    Location
    Europe
    MS-Off Ver
    Excel for Microsoft 365
    Posts
    2,028

    Re: Populate Text Boxes based on Combo Box Selection

    hi Sasha,
    the simpliest way is to attach a test file, remove your personal or confidential data and
    "Post a WORKBOOK. Nobody wants to type data from a picture or paste text from your post into a spreadsheet as a prelude to helping. To attach a file, push the button with the paperclip (or scroll down to the Manage Attachments button), browse to the required file, and then push the Upload button."
    Regards, John55
    If you have issues with Code I've provided, I appreciate your feedback.
    In the event Code provided resolves your issue, please mark your Thread as SOLVED.
    If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.

    ...enjoy -funny parrots-

  6. #6
    Registered User
    Join Date
    04-01-2012
    Location
    Texas
    MS-Off Ver
    Excel 2010
    Posts
    4

    Re: Populate Text Boxes based on Combo Box Selection

    sorry about the code tags. I've revised my original post to include them. Thanks for the 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