'Show a dropdown validation list without using SendKeys
I'm trying to automate data entry of 1500+ ripped movies in an Excel table (ListObject) with the help of data validation lists to avoid entry errors. I'd like to write the code so that when the movie title is entered, a validation list for filenames automatically drops down in the adjacent filename column to allow selection of a video file. There will be thousands of cells where I will use such a validation list. Currently I accomplish this using SendKeys "{%Down}" but I'd like to avoid SendKeys. Has anyone got experience doing this? Is it possible?
TIA
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|