+ Reply to Thread
Results 1 to 13 of 13

Open Drop Down List On Double Click

  1. #1
    Forum Expert NeedForExcel's Avatar
    Join Date
    03-16-2013
    Location
    Pune, India
    MS-Off Ver
    Excel 2016:2019, MS 365
    Posts
    3,873

    Open Drop Down List On Double Click

    Hi,

    Is there a way with VBA, where we can Open a Drop Down List On Before Double Click event?

    This is the stage I want to land at when I double click on the cell..
    Attached Images Attached Images
    Cheers!
    Deep Dave

  2. #2
    Forum Expert skywriter's Avatar
    Join Date
    06-09-2014
    Location
    USA
    MS-Off Ver
    2016
    Posts
    2,760

    Re: Open Drop Down List On Double Click

    What is that a data validation drop down? Form control combo box? Active X?
    Click the * Add Reputation button in the lower left hand corner of this post to say thanks.

    Don't forget to mark this thread SOLVED by going to the "Thread Tools" drop down list above your first post and choosing solved.

  3. #3
    Forum Expert NeedForExcel's Avatar
    Join Date
    03-16-2013
    Location
    Pune, India
    MS-Off Ver
    Excel 2016:2019, MS 365
    Posts
    3,873

    Re: Open Drop Down List On Double Click

    Its a regular DV Drop Down..

  4. #4
    Forum Expert skywriter's Avatar
    Join Date
    06-09-2014
    Location
    USA
    MS-Off Ver
    2016
    Posts
    2,760

    Re: Open Drop Down List On Double Click

    With an Actitve X combo box there's a drop down method. I created an Active X combo box on a worksheet and in the worksheet code this caused the combo box to drop down.

    Please Login or Register  to view this content.

  5. #5
    Forum Expert NeedForExcel's Avatar
    Join Date
    03-16-2013
    Location
    Pune, India
    MS-Off Ver
    Excel 2016:2019, MS 365
    Posts
    3,873

    Re: Open Drop Down List On Double Click

    Nope! That wont help..

    I have a DV Drop Down, and I can't change that unfortunately..

    I knew there was a way with Actitve X Combo Boxes

  6. #6
    Forum Expert skywriter's Avatar
    Join Date
    06-09-2014
    Location
    USA
    MS-Off Ver
    2016
    Posts
    2,760

    Re: Open Drop Down List On Double Click

    Okay so I found this and it seems to work. I put my drop down list in B1.

    Actually I couldn't get it to work until I added in the selection change event code. I don't know why, but it works.

    Please Login or Register  to view this content.
    Last edited by skywriter; 09-04-2015 at 03:49 AM.

  7. #7
    Forum Guru romperstomper's Avatar
    Join Date
    11-04-2008
    Location
    A1
    MS-Off Ver
    Most
    Posts
    12,302

    Re: Open Drop Down List On Double Click

    Why would you do this? It's actually more effort than just clicking the dropdown arrow...
    Remember what the dormouse said
    Feed your head

  8. #8
    Forum Expert NeedForExcel's Avatar
    Join Date
    03-16-2013
    Location
    Pune, India
    MS-Off Ver
    Excel 2016:2019, MS 365
    Posts
    3,873

    Re: Open Drop Down List On Double Click

    @skywriter I am unable to get it working.. Can you post a sample workbook?

  9. #9
    Forum Expert NeedForExcel's Avatar
    Join Date
    03-16-2013
    Location
    Pune, India
    MS-Off Ver
    Excel 2016:2019, MS 365
    Posts
    3,873

    Re: Open Drop Down List On Double Click

    Quote Originally Posted by romperstomper View Post
    Why would you do this? It's actually more effort than just clicking the dropdown arrow...
    Actually its not. Normally you have to click on the cell once, and then precisely click on the Drop Down Arrow, here you can simply double click anywhere on the cell.

    Besides, I am going to put it in between the selection change event.. Which makes more sense with the way my workbook is designed..

  10. #10
    Forum Guru romperstomper's Avatar
    Join Date
    11-04-2008
    Location
    A1
    MS-Off Ver
    Most
    Posts
    12,302

    Re: Open Drop Down List On Double Click

    Personally I would find that quite irritating in a SelectionChange event, but:
    Please Login or Register  to view this content.

  11. #11
    Forum Expert skywriter's Avatar
    Join Date
    06-09-2014
    Location
    USA
    MS-Off Ver
    2016
    Posts
    2,760

    Re: Open Drop Down List On Double Click

    I also noticed if the drop down list in B1 is not active and you select the cell, not the drop down arrow, it just opens automatically. So double click on a cell not B1 and the drop down should open. It works fine for me.
    Attached Files Attached Files

  12. #12
    Forum Expert skywriter's Avatar
    Join Date
    06-09-2014
    Location
    USA
    MS-Off Ver
    2016
    Posts
    2,760

    Re: Open Drop Down List On Double Click

    romperstomper's DOWN key code works in the before double click event without the do events and without needing the selection change code. Everything I found on the internet was UP and it didn't work until I added the code into the selection change event. When I saw it was working I mistakenly thought I did something wrong in the double click code that I had somehow fixed. I then noticed the selection change code and decided to comment it out and that's when I noticed it quit working when I double clicked.

    Please Login or Register  to view this content.

  13. #13
    Forum Expert NeedForExcel's Avatar
    Join Date
    03-16-2013
    Location
    Pune, India
    MS-Off Ver
    Excel 2016:2019, MS 365
    Posts
    3,873

    Re: Open Drop Down List On Double Click

    Thank you both.. Both work fine..

    romperstomper's solution is exactly what I am looking at..

    Cheers!

    Rep added and marking the thread solved..

+ 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. Double click cell - copy data to new sheet - create a list from double clicking
    By kakky in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 05-04-2015, 11:14 PM
  2. Excel won't open on double click
    By boutells in forum Excel General
    Replies: 14
    Last Post: 01-15-2015, 09:57 AM
  3. Double Click vs Open XLTM
    By [email protected] in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 02-18-2014, 01:06 PM
  4. Calendar open with a double click
    By nik7 in forum Excel General
    Replies: 8
    Last Post: 04-08-2013, 07:54 AM
  5. files do not open with double click
    By mgrimz in forum Excel General
    Replies: 2
    Last Post: 04-14-2006, 08:10 PM
  6. can't open file by double click
    By Mike Morn in forum Excel General
    Replies: 1
    Last Post: 11-16-2005, 01:52 PM
  7. [SOLVED] why do 5 workbooks open when I double click one
    By dnlighting in forum Excel General
    Replies: 2
    Last Post: 08-15-2005, 04:05 PM

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