+ Reply to Thread
Results 1 to 3 of 3

is it possible to use combo multi options for a cell?

  1. #1
    Registered User
    Join Date
    05-04-2013
    Location
    Canada
    MS-Off Ver
    Excel 2016
    Posts
    67

    is it possible to use combo multi options for a cell?

    I have two sheets, sheet1 defines categories, sheet2 defines use case and its categories.

    As each use case could link to multiple categories, I wonder is there a way to create a checkbox to allow multi selection for the correspondent categories for each use case, the checkbox should be populated from the sheet1 category.

    The initial excel is attached here just in case.

    Thank you very much.
    Attached Files Attached Files

  2. #2
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: is it possible to use combo multi options for a cell?

    It is always easier to advise if we can see your request in its context.

    Show a before and after situation with manually calculated results, explaining which information is data and which is results, and if it's not blindingly obvious how you have arrived at your results some explanatory notes as well.
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  3. #3
    Registered User
    Join Date
    05-04-2013
    Location
    Canada
    MS-Off Ver
    Excel 2016
    Posts
    67

    Re: is it possible to use combo multi options for a cell?

    Thank you for your reminder.

    I am wrapping up my study use case on AWS, I will populate the use case field from my study, I want to have a checkbox field so I can select from

    Attached here is the sample for the result that I am expecting.

    Note:
    Main Category is the field that I want to have a checkbox option there for me to select from, the checkbox will help to prevent from mis typing.

    Thank you.

+ 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. combo box options based on another combo box in different userform
    By bujaber10 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-21-2019, 03:08 PM
  2. Replies: 2
    Last Post: 01-19-2015, 06:52 PM
  3. [SOLVED] Combo Box with options depanted of another combo box.
    By MariaPap in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-25-2014, 04:34 AM
  4. [SOLVED] Excel 2010 VBA – Combo Box Options– Clear cell/box in 2nd Combo when 1st Combo selected
    By theshybutterfly in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-17-2013, 07:25 PM
  5. Multi-Column Counting - COUNTA or other Options
    By argomike in forum Excel Formulas & Functions
    Replies: 34
    Last Post: 01-28-2012, 03:54 PM
  6. Combo Box multi select into 1 cell
    By The_Vulcan in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-19-2007, 01:34 AM
  7. Cell options/combo box?
    By Paulymon in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-17-2006, 02:50 PM

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