+ Reply to Thread
Results 1 to 3 of 3

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

  1. 12-05-2019, 09:19 AM #1
    prvnchdry
    prvnchdry is offline
    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
    Reply With QuoteRegister To Reply
  2. 12-05-2019, 09:43 AM #2
    davesexcel
    davesexcel is offline
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,480

    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.
    ,
    Xlorate.com, Selection Codes, YouYube Channel
    Reply With QuoteRegister To Reply
  3. 12-05-2019, 10:17 AM #3
    prvnchdry
    prvnchdry is offline
    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 With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next 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. In-cell drop down list, show from one list but output from another?
    By ppgab in forum Excel General
    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. How to add the drop down list items selected in another cell
    By tshl in forum Excel General
    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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1