In Excel VBA return the text from a dropdown box rather than the index number - Stack Overflow

I have the following VBA code (from MS Access 2007). The code creates a new workbook and adds a dropdown to a cell. This small snippet adds a drop down to a particular cell ...

stackoverflow.com