+ Reply to Thread
Results 1 to 3 of 3

Display string(s) based on checkbox selection

  1. #1
    Forum Contributor
    Join Date
    10-15-2009
    Location
    Broooklyn, NY
    MS-Off Ver
    Excel 2016
    Posts
    207

    Display string(s) based on checkbox selection

    So, I have different types of fabric. I want cell E8 to display the strings, which is based on checkbox selection. So, if Silk and Denim checkboxes are selected, silk and denim should be displayed in cell E8.
    Attached Files Attached Files

  2. #2
    Banned User!
    Join Date
    02-26-2020
    Location
    US
    MS-Off Ver
    2010
    Posts
    157

    Re: Display string(s) based on checkbox selection

    Hi,

    Maybe this array instead:

    Formula: copy to clipboard
    Please Login or Register  to view this content.


    Press CTRL+SHIFT+ENTER to make it an array.

  3. #3
    Forum Contributor
    Join Date
    10-15-2009
    Location
    Broooklyn, NY
    MS-Off Ver
    Excel 2016
    Posts
    207

    Re: Display string(s) based on checkbox selection

    It doesn't work. Can you take a look at the attachment?

+ 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] Set Userform Checkbox value to True if CheckBox.Caption string is found in another String
    By TFiske in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-28-2018, 03:39 PM
  2. [SOLVED] Replace Rows Based on Checkbox Selection
    By pkardt in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-26-2016, 07:49 PM
  3. Display 1 or 0 based on Checkbox selection - On Radio Button Click
    By gmalpani in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-17-2014, 05:37 AM
  4. [SOLVED] Looking for some help on hiding columns based on checkbox selection
    By Spritz in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 06-07-2013, 10:38 AM
  5. Run Macro(s) based on checkbox selection(s)
    By koodicoderi in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-04-2013, 10:20 AM
  6. Dynamic Userform (resizing based on checkbox selection)
    By gazza365 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-13-2011, 04:50 PM
  7. Trying to run macro based on checkbox selection
    By caliskier in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-23-2008, 05:45 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