+ Reply to Thread
Results 1 to 2 of 2

How do I get a drop down list to appear if I click on a cell

  1. #1
    Registered User
    Join Date
    05-17-2018
    Location
    South Africa
    MS-Off Ver
    2016
    Posts
    1

    How do I get a drop down list to appear if I click on a cell

    I have already added a drop down list, using the Data Validation functionality. Currently, if I select the cell, it is blank, and I have to select the arrow button in order to display the drop down options.

    Can I have the drop down options show as soon as I select the cell, without having to select the arrow button?

    Thanks!

  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    12,947

    Re: How do I get a drop down list to appear if I click on a cell

    The key strokes to drop the list is Alt & Down Arrow

    You could use the sendkeys application, it does cause problems with the number lock if you have too many send key commands at a time.

    For practice purposes, have the data validation in A1

    In the worksheet module, enter this code, then select A1

    Please Login or Register  to view this content.

    Right click the sheet tab and select view code to get to the worksheet module.
    -
    -

    RightClickTab.jpg

+ 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. Drop down list display instantly (no arrow click)?
    By jokris in forum Excel - New Users/Basics
    Replies: 8
    Last Post: 03-19-2016, 04:29 PM
  2. [SOLVED] Open Drop Down List On Double Click
    By NeedForExcel in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 09-04-2015, 05:05 AM
  3. Replies: 3
    Last Post: 05-17-2014, 12:06 AM
  4. [SOLVED] Reset Drop Lists When Click on first list
    By work4nutz in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 10-29-2013, 02:43 PM
  5. Drop list to run a macro on click
    By RobM_01 in forum Excel - New Users/Basics
    Replies: 6
    Last Post: 10-21-2011, 08:23 AM
  6. Replies: 3
    Last Post: 09-03-2010, 08:00 AM
  7. Replies: 2
    Last Post: 03-10-2006, 11:10 AM

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