The PyXLL/Jupyter interface would be drab without custom menus and graphical feedback.
I built an Excel dropdown function — that requires no worksheet reference!
The dropdown built into Excel requires a range of data to populate the dropdown list. This might be an appropriate situation if the spreadsheet is a one-off. In my work, the dropdown list would more appropriately be generated in my PyXLL program.