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..
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..
Cheers!
Deep Dave
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.
Its a regular DV Drop Down..
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.
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
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.
Why would you do this? It's actually more effort than just clicking the dropdown arrow...
Remember what the dormouse said
Feed your head
@skywriter I am unable to get it working.. Can you post a sample workbook?
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..
Personally I would find that quite irritating in a SelectionChange event, but:
Please Login or Register to view this content.
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.
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.
Thank you both.. Both work fine..
romperstomper's solution is exactly what I am looking at..
Cheers!
Rep added and marking the thread solved..
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks