+ Reply to Thread
Results 1 to 3 of 3

Create drop-down list with checkboxes and show output of the Selected Items

  1. #1
    Registered User
    Join Date
    05-10-2017
    Location
    BANGALORE
    MS-Off Ver
    2016
    Posts
    21

    Create drop-down list with checkboxes and show output of the Selected Items

    Hi All

    Through some google search I found a code which would reflect the output based on the checkbox list i.e. in cell AZ9 (please see attached). Being very new to VBA coding, I am unable to fix two things

    1) Options selected in the checkbox list should reflect as an output in any selected cell (and not just to cell AZ9) when clicked on "Select options" box

    2) More than 1 option when chosen is separated with a semicolon. Can there be a space inserted after the semicolon and/or appear as a list instead?

    Will really appreciate any help from this forum

    Thank you in advance!
    Attached Files Attached Files

  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    12,514

    Re: Create drop-down list with checkboxes and show output of the Selected Items

    This is what is used as the string seperator xSelLst = xLstBox.List(I) & ";" & xSelLst you can add a space to it "; " or use anything,
    whatever string you use as a separator would have to be in quotes.

    If you want each item on a seperate line then
    Please Login or Register  to view this content.

    This lines of code is placing the text in Z29

    Please Login or Register  to view this content.
    Change the range to activecell

    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    05-10-2017
    Location
    BANGALORE
    MS-Off Ver
    2016
    Posts
    21

    Re: Create drop-down list with checkboxes and show output of the Selected Items

    Exactly what I was looking for, Thanks a ton Dave!

+ 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. Filter list to show only selected items
    By andrew_senior4 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 12-04-2018, 10:47 AM
  2. To create a list of items in which certain items can be selected and printed
    By swashbuckler in forum Excel - New Users/Basics
    Replies: 3
    Last Post: 03-05-2017, 01:26 PM
  3. Replies: 1
    Last Post: 03-02-2015, 09:04 AM
  4. Counting Items selected from a drop down list
    By tgale in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 3
    Last Post: 06-20-2014, 05:09 PM
  5. [SOLVED] Using an array to create a list of selected items
    By Harribone in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-02-2014, 04:40 PM
  6. Replies: 1
    Last Post: 08-01-2013, 07:55 PM
  7. [SOLVED] Apperance of selected items from drop down list in different cell
    By pointman787 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 08-25-2012, 12:28 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