+ Reply to Thread
Results 1 to 5 of 5

Help! How do i populate a cell with the values selected from a multiselect listbox?

  1. #1
    Registered User
    Join Date
    04-11-2013
    Location
    london
    MS-Off Ver
    Excel 2007
    Posts
    3

    Help! How do i populate a cell with the values selected from a multiselect listbox?

    Hello
    I'm a new to VBA and I've just created a multiselect listbox. Which seems to work fine, but now I want to be able to populate a cell or a range of cells with the values that has been selected by the user.

    For example

    my list is:
    • Options
      Swaps
      Futures
      Derivatives
      Money Markets
      Treasury
    If a user selects Options and futures, then I want to be able to see that information in cell A5 and A6 and so on or have it displayed in the easiest way so I can create formulas based on the output.


    Thank you!

  2. #2
    Forum Expert
    Join Date
    11-28-2012
    Location
    Guatemala
    MS-Off Ver
    Excel 2010
    Posts
    2,394

    Re: Help! How do i populate a cell with the values selected from a multiselect listbox?

    could you send a sample of the actions to be taken depending on the selection?

  3. #3
    Registered User
    Join Date
    04-11-2013
    Location
    london
    MS-Off Ver
    Excel 2007
    Posts
    3

    Re: Help! How do i populate a cell with the values selected from a multiselect listbox?

    thanks for your reply
    for example

    my row source is b1:b6 - then if that list item is selected, i want to see in rows A1:A6 TRUE the item has been selected, FALSE = it has not been selected. hiope that makes sense...

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

    Re: Help! How do i populate a cell with the values selected from a multiselect listbox?

    Can you clarify what you want to do?

    In the first post you seem to be saying you wanted to see the selected items in cells, in the latest you seem to want TRUE/FALSE in the column next to the list of items.
    If posting code please use code tags, see here.

  5. #5
    Registered User
    Join Date
    04-11-2013
    Location
    london
    MS-Off Ver
    Excel 2007
    Posts
    3

    Re: Help! How do i populate a cell with the values selected from a multiselect listbox?

    which ever one is easiest -

    i want to see the results of what has been selected from my listbox in a cell. So it can either be True or false or the cell can be populated with the list item selected.

+ 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