Share via

Auto Display Drop Down List

Anonymous
2023-02-19T16:14:39+00:00

I have created a drop-down list in Excel and its woks fine if I click the drop-down button. I would like the list to display as soon as the cell is selected without having to click the drop-down button

Microsoft 365 and Office | Excel | For business | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2023-02-20T01:31:36+00:00

    Dear DS Bell,

    Good day! Thank you for posting to Microsoft Community. We are happy to help you.

    Per the description shared, I would like to summarize your requirement i.e., you would like to show the items in the drop-down list without clicking on the drop-down arrow.

    If my understanding is correct, as per my experience it's not possible to meet your requirement via setting or formula but I guess it can be achieved by using VBA Macros. So, I would like to suggest you to post your concern in the VBA Community to get more help from experts. Office VBA support and feedback | Microsoft Learn

    In addition, I will keep this thread open so Excel MVPs and experts can share their ideas and views on your requirement.

    Thanks for your cooperation.

    Sincerely,

    Mia | Microsoft Community Moderator

    Was this answer helpful?

    0 comments