+ Reply to Thread
Results 1 to 4 of 4

Listbox to textbox userform

  1. #1
    Registered User
    Join Date
    05-23-2016
    Location
    California
    MS-Off Ver
    2013
    Posts
    20

    Listbox to textbox userform

    Hello, I am very very new to userform and am self teaching how to use it. I am trying to create a list that once an choice is picked it will populate corresponding data into a textbox the user can see. More detailed. I have have a list of location names if location 1 is picked I want the textbox to populate the address and phone number. Is something like this possible?

  2. #2
    Forum Expert mikerickson's Avatar
    Join Date
    03-30-2007
    Location
    Davis CA
    MS-Off Ver
    Excel 2011
    Posts
    6,229

    Re: Listbox to textbox userform

    I think that something like this would work for you.

    Please Login or Register  to view this content.
    For the multi-data problem, you'ld use a multi-column list box and more than one text box.
    Please Login or Register  to view this content.
    _
    ...How to Cross-post politely...
    ..Wrap code by selecting the code and clicking the # or read this. Thank you.

  3. #3
    Registered User
    Join Date
    05-23-2016
    Location
    California
    MS-Off Ver
    2013
    Posts
    20

    Re: Listbox to textbox userform

    Thanks for the help, I'm trying to adjust it for what I need but I appreciate the input. Like I said I'm very new to this. I taught myself excel kinda and now am learning userform kinda, so it's a bit tricky but I like it.

  4. #4
    Forum Expert mikerickson's Avatar
    Join Date
    03-30-2007
    Location
    Davis CA
    MS-Off Ver
    Excel 2011
    Posts
    6,229

    Re: Listbox to textbox userform

    That's the way that I learned. Good luck. Feel free to post back with more questions.

+ 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. VBA - Userform - Listbox validation and Listbox to Textbox
    By stevefisher85 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-04-2016, 07:11 AM
  2. Listbox and Userform to populate textbox - Help!
    By reyreyreyes in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-22-2015, 01:32 PM
  3. [SOLVED] Filtering a Listbox with a textbox in a userform
    By Aris in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-02-2014, 06:16 AM
  4. [SOLVED] populate userform listbox from textbox input
    By cfinch100 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 04-05-2013, 10:05 AM
  5. fill a listbox from textbox of other tab of userform in excel vba
    By kmlprtsngh in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 10-22-2010, 03:36 AM

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