How to very easily load an Excel range into the ribbon as a dropdown The code provided in this repository will show you, very easily, how to use a range of your workbook as source data for a dropdown ...

Automating the selection process isn't difficult if you rely on VBA's InputBox in Microsoft Excel.