+ Reply to Thread
Results 1 to 3 of 3

Populating a Listbox according to checkbox selection

  1. #1
    Registered User
    Join Date
    07-16-2016
    Location
    Belo Horizonte, Brazil
    MS-Off Ver
    2016
    Posts
    22

    Populating a Listbox according to checkbox selection

    Hey everyone,

    I have a worksheet where the information is displayed in the following manner: a table containing 3 columns:

    A - List of objects
    B - Categories
    C - Comments

    I have a userform in VBA that is built in the following manner:

    4 checkboxes (corresponding to the 4 categories existing in column B)
    1 listbox
    1 textbox

    What I want it to do is:
    I want the listbox to return the objects in column A, corresponding to the categories that have been checked in the Checkboxes!


    Once that is running, I want that, upon selecting one item in the listbox, the textbox displays the comment contained in the third column of the corresponding line.

    If it wasn't clear enough, please let me know!
    Thanks in advance for your support!

    [reposting from https://www.mrexcel.com/forum/excel-...ormation.html]

  2. #2
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,646

    Re: Populating a Listbox according to checkbox selection

    Any chance you could upload a sample workbook?

    Click on GO ADVANCED, scroll down and click Manage Attachments.
    If posting code please use code tags, see here.

  3. #3
    Registered User
    Join Date
    07-16-2016
    Location
    Belo Horizonte, Brazil
    MS-Off Ver
    2016
    Posts
    22

    Re: Populating a Listbox according to checkbox selection

    It has been solved!

    Link to the answered post: https://www.mrexcel.com/forum/excel-...formation.html

    Thank you!

+ 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] UserFrom Checkbox Selection not populating Cells
    By midnightorion in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-10-2015, 11:21 PM
  2. Populating userform word boxes based on listbox selection
    By trcrossland in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 11-12-2014, 12:55 PM
  3. [SOLVED] Need help with populating Listbox from another Listbox(selection); across userforms.
    By SoulPrisoner in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-28-2013, 12:54 PM
  4. Populating a Range of Cells from a ListBox Selection
    By cmaitlen in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-03-2012, 07:06 PM
  5. Multi select Listbox Items selection based on other Listbox item selection.
    By srinivassathi in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-20-2011, 05:53 AM
  6. Populating a userform based on a listbox selection
    By hey1000 in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 07-21-2010, 02:54 AM
  7. [SOLVED] Populating listbox on the basis of Combo box selection.
    By abhay_547 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-19-2010, 04:41 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