+ Reply to Thread
Results 1 to 2 of 2

Show dynamic values at listbox depending value selected another listbox

  1. #1
    Registered User
    Join Date
    01-08-2017
    Location
    Barcelona
    MS-Off Ver
    Office 2019
    Posts
    82

    Show dynamic values at listbox depending value selected another listbox

    Hi everyone

    I'm starting with vba early and I don't know mucho more for now. I'm trying to put some value of a range at column A that have variable size and show into ListBox2 the values are at his row (also variable size).

    for exaxmple If I selected value from a2 at ListBox1 show at Listbox2 values from B2 until column2 that have values (in this case C2). If select A3 show B3 until C3 ....

    Also I want to do this with arrays and give the posibiliti to update this values (remove, adding or modify). I think this must be make it with cycles for or something and property ListBox Selected but I don't achieve the solution. Any help will or sugest how can read will be fantastic

    I upload a test file I beguinin with, it is por and badly and I know it have lot of mistakes (names given to the arrays) etc. I'm working in it.

    For mistake I upload the file and message at General forum and I don't know how to move to this forum. I linked it in order to give access to the file I've upload http://www.excelforum.com/showthread.php?t=1171200&p=4567748#post4567748

  2. #2
    Forum Expert
    Join Date
    08-16-2015
    Location
    Antwerpen, Belgium
    MS-Off Ver
    2007-2016
    Posts
    2,380

    Re: Show dynamic values at listbox depending value selected another listbox

    See

    http://www.excelforum.com/showthread.php?t=1171200

    Kind regards
    Leo

+ 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. Replies: 7
    Last Post: 01-29-2017, 03:22 PM
  2. Populate (ca 200) Txtboxes depending on listbox selection, live-filter for listbox &1 more
    By InternInNeed in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-14-2016, 09:56 AM
  3. Show dynamic data depending on selection of item from listbox.
    By MOHAMMESALMAN in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-02-2015, 02:21 AM
  4. Userform ListBox depending on a previous Listbox selection
    By Figolu in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-23-2015, 04:31 PM
  5. Userform ListBox depending on a previous Listbox selection
    By Figolu in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-23-2015, 02:08 PM
  6. [SOLVED] Indexing proper range in listbox depending on selection in previous listbox
    By bloodmeat in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-02-2013, 02:31 PM
  7. [SOLVED] Populating a Worksheet with values selected from a Dynamic Listbox
    By hornbyOO in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-09-2012, 04:35 PM

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