Results 1 to 6 of 6

Thread: Auto Show Drop-Down List When Selecting the Cell

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Member
    Join Date
    May 2020
    Posts
    66
    Rep Power
    4

    Auto Show Drop-Down List When Selecting the Cell

    Moderator Notice:
    Solved by Peter SSs here:
    https://www.mrexcel.com/board/thread...-cell.1144911/








    Hello!
    I have craeted a simple drop down menu with the help of data validation in cell "B3". The list contains 4 options, A,B,C and D. (Please see the attachment)
    Clicking.png

    Now, as we all know, If I want to see this 4 option or select any one of them, I must first select the cell "B3". Then a down arrow will appear on right side of the cell. Selection.png

    Only after Clicking this arrow, we can see the list. Clicking.png

    My Requirement:
    Just after selecting the cell "B3", the drop down list should appear automatically, without clicking the down arrow shown in right side of the cell.


    Is there any way, any Macro, anything else to do that??

    I do not want to use User Form. It may make the things more complicated, while I want to make the things more easy!

    Thanks in Advance!!
    Attached Files Attached Files
    Last edited by DocAElstein; 11-09-2020 at 03:17 PM.

Similar Threads

  1. Replies: 4
    Last Post: 04-25-2014, 04:23 PM
  2. A code to show colour in cell from list
    By rodneykaye in forum Excel Help
    Replies: 4
    Last Post: 10-18-2013, 03:56 PM
  3. Replies: 4
    Last Post: 07-27-2013, 01:34 PM
  4. Replies: 2
    Last Post: 07-23-2013, 06:54 PM
  5. Auto Unique List
    By r_know in forum Excel Help
    Replies: 8
    Last Post: 07-19-2012, 09:28 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •