+ Reply to Thread
Results 1 to 2 of 2

Open the Searchable Drop Down List on Enter

  1. #1
    Forum Contributor
    Join Date
    10-27-2005
    Posts
    177

    Open the Searchable Drop Down List on Enter

    Hi everyone.

    I would really appreciate any help on this.

    Please see attached.

    I have created a searchable drop down list (cell D2 in Searchable sheet). When I enter a search string, I have to click on the down arrow button of to see the search results.

    Is there a way so that after typing the search string and pressing [Enter], the list opens to show the search results?

    I'm guessing this would involve application.onkey but I'm lost on how to use it. So basically, it's something like .. if cell D2 is edited (ie. a search string is inputted) and the Enter button is pressed, then open the list box. How would this be coded in VBA?

    Any suggestions would be much appreciated.
    Attached Files Attached Files
    Last edited by uberathlete; 03-09-2014 at 04:53 PM.

  2. #2
    Forum Contributor
    Join Date
    10-27-2005
    Posts
    177

    Re: Open the Searchable Drop Down List on Enter

    Sorry ... bump

+ 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. enter data in the drop down list cell?
    By sanlen in forum Excel General
    Replies: 3
    Last Post: 12-17-2010, 12:02 AM
  2. Enter values from drop down list
    By nsv in forum Excel General
    Replies: 3
    Last Post: 09-01-2010, 08:53 AM
  3. Auto Enter Drop Down List Items
    By JBC in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 09-23-2009, 12:40 PM
  4. Searchable drop down menu?
    By Christoffer_Col in forum Excel General
    Replies: 1
    Last Post: 03-05-2009, 05:04 AM
  5. Keystroke to enter drop-down list?
    By Bruce Cooley in forum Excel General
    Replies: 3
    Last Post: 06-30-2005, 12:05 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