I would like a drop down list to display instantly when clicking a cell that allows me to choose from a drop down list.
As of now, I first click the cell, then I click the arrow before I choose in my drop down list.
I would like to skip the "click the arrow"-part.
How do I achieve this?
please upload a sample workbook with description there what u want to achieve.
If answer helped you say Thanks by Add Reputation
Here is a link for downloading an example, drop down list is in cell A1
http://s000.tinyupload.com/index.php...81137324322330
Hi jokris,
See if something like this is what you want.
Sendkeys to drop down validation list.xlsm
Please Login or Register to view this content.
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
Please upload your file to the forum. Not all members are able - or willing - to access file-hosting sitesOriginally Posted by jokris
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Hello jokris,
Please beware of send keys, as it can sometimes be quite erratic. It may turn your num lock off and then you may have to add an API call to turn it back on again.
Instead of a Cell Validation with a Dropdown, I would suggest you use a Combo Box approach, as demonstrated in the attached sample Workbook.I would like to skip the "click the arrow"-part.
Regards.
Please consider:
Be polite. Thank those who have helped you. Then Click on the star icon in the lower left part of the contributor's post and add Reputation. Cleaning up when you're done. If you are satisfied with the help you have received, then Please do Mark your thread [SOLVED] .
There's an add-in at https://app.box.com/shared/ono8ni9xvr that will do that, a ReadMe at https://app.box.com/shared/4qxybepxxr, and an example workbook at https://app.box.com/shared/e8dbbple34
Entia non sunt multiplicanda sine necessitate
@shg,
The OP states that;I have tried all the links provided in your Post, none of which seems to fulfil the specified requirement.I would like to skip the "click the arrow"-part.
Am I missing something somewhere?
Kind Regards.
Did you install the add-in, then select a cell with list validation?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks