1. Welcome to Chandoo.org Forums. Short message for you

    Hi Guest,

    Thanks for joining Chandoo.org forums. We are here to make you awesome in Excel. Before you post your first question, please read this short introduction guide. When posting or responding to questions please remember our values at Chandoo.org are: Humility, Passion, Fun, Awesomeness, Simplicity, Sharing Remember that we have people here for whom English is not there first language and we need to allow for this in our dealings.

    Yours,
    Chandoo
  2. Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  3. When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Multi select drop-down without VBA

Discussion in 'Ask an Excel Question' started by Nithya James, Jul 11, 2018.

  1. Nithya James

    Nithya James New Member

    Messages:
    3
    Dear Excel users,
    I have a excel sheet where I want to restrict the users to select values from the drop down, which I can do it easily using data validation. But I want to select multiple options from the drop down list without using any VBA script. Is that possible using any conditional formatting or cell formatting? or any alternative approach to select multiple options to select multiple values from the given cell, without using macro ?
  2. Chihiro

    Chihiro Excel Ninja

    Messages:
    4,935
    Welcome to the forum.

    I don't think it's have multiple selection made in single cell without some sort of code. But I'm not sure I get what you are trying to achieve.

    If you can mock up how your workbook looks like and where you want users to make multiple selection from list, and where the result should be displayed. May be we can help.
  3. Nithya James

    Nithya James New Member

    Messages:
    3
    Hi Chihiro,
    In this excel sheet, when you see the 'update_sheet', in some columns (ghs_statement, statement) there is a drop down where we restrict the customers to select the value from it. It is now using VBA to enable the multi select feature, but I want to replicate the same either in python script (or) using some formula

    Attached Files:

  4. Chihiro

    Chihiro Excel Ninja

    Messages:
    4,935
    Ok, you won't be able to do this without VBA in Excel.

    I haven't used Python to manipulate Excel workbook, other than loading existing data from Excel and writing back transformed data (or running web query on python and outputting result to Excel).

    I'd imagine it is possible to create entire set up including GUI in python.
    https://wiki.python.org/moin/GuiProgramming

    Then create/write to workbook in memory using OpenPyXL.
    https://openpyxl.readthedocs.io/en/stable/tutorial.html

    But my recommendation is to stick with VBA, writing this out in python will be more work than what it's worth.

    I'm curious, is there specific reason why you want to avoid VBA in this workbook? There's other components of this workbook that requires VBA.

    If above isn't what you are looking for... perhaps leverage one of following if you have Office 365 subscription.
    • Forms - Multi select radial
    • SharePoint - Use list and Lookup Column with Multi Select
    For SharePoint option, you'd need External Users Sharing turned on.
    Thomas Kuriakose likes this.
  5. Nithya James

    Nithya James New Member

    Messages:
    3
    I wanted to move out of VBA because I want to upload the result file to a tool which accepts only .xlsx files not .xlsm files.
  6. Chihiro

    Chihiro Excel Ninja

    Messages:
    4,935
    Why not just save the end result sheet as xlsx?

    I'm not sure what your use case is. Since the workbook itself is designed to generate XML file for upload...

Share This Page