+ Reply to Thread
Results 1 to 4 of 4

Macro that shows what is selected in a multiselect listbox

  1. #1
    Registered User
    Join Date
    08-27-2012
    Location
    Los Angeles, CA
    MS-Off Ver
    Excel 2010
    Posts
    6

    Macro that shows what is selected in a multiselect listbox

    I have a form that contains mulitselect listboxes, I've displayed an image of one below. Is there a macro or funcition that returns a list of what has been selected in the listbox.

    Capture.PNG

    For example, for this image, a "Hammer, Scissors, Scrap block of Word" would be displayed.
    Last edited by Briansva92; 08-31-2012 at 03:45 PM.

  2. #2
    Valued Forum Contributor Charles's Avatar
    Join Date
    02-10-2004
    Location
    Biloxi
    MS-Off Ver
    Windows 7, Excel 2003,2007 & Mac2011
    Posts
    845

    Re: Macro that shows what is selected in a multiselect listbox

    Hi,

    Not tested but this may help.

    Please Login or Register  to view this content.
    Charles

    There are other ways to do this, this is but 1 !
    Be Sure you thank those who helped.
    IF YOU'RE SATISFIED BY ANY MEMBERS RESPONSE TO YOUR ISSUE PLEASE USE THE STAR ICON AT THE BOTTOM LEFT OF THE POST UNDER THEIR NAME.

  3. #3
    Registered User
    Join Date
    08-27-2012
    Location
    Los Angeles, CA
    MS-Off Ver
    Excel 2010
    Posts
    6

    Re: Macro that shows what is selected in a multiselect listbox

    Hey,

    Thanks for the response. I'm having trouble using this macro. the multi select listbox is in a workbook, not a user fan. Hwo do I reference the list box like this: " If ListBox1.Selected(i) = True Then"? Even when I create a new workbook and try and run the macro with a listbox called ListBox1 there is an error at this line. any thoughts on why?

  4. #4
    Valued Forum Contributor Charles's Avatar
    Join Date
    02-10-2004
    Location
    Biloxi
    MS-Off Ver
    Windows 7, Excel 2003,2007 & Mac2011
    Posts
    845

    Re: Macro that shows what is selected in a multiselect listbox

    Hi,

    See if the code helps. It's for the "MsForm".

    Please Login or Register  to view this content.

+ 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