Open Drop down list by selecting cell

[barqujo]

Hello everyone!!

Quick question

I have a Data Validation dropdown list in A1. How can I make the drop down list to open when I select the cell? Not by clicking the little arrow button on the right that appears by default??


Thank you!!!

[AYData]

Not practical to set it up that way. Think about it for a minute. What would happen if you select a cell and this drop-down list pops up, then you realise your in wrong cell, and need the cell below the one your in. But you can't just move down one cell because there would be a drop-down list in the way and the cursor would just move down your drop-down list, not move down a row. Totally impractible for vision impaired or others with a disability. That may not effect you, but there could be others that might have to use the same workbook.

[Solus Rankin]

Please Login or Register  to view this content.