Forum Discussion
Macros in Excel dropdown box
@mathetes Thank you for responding, sorry if I was vague, this is the first time I have asked for assistance. I am wanting to create a drop down box with the selection of a specific worksheet, ...
Alternatively, you could try using this command in your return to sheets macro to display and use excel's built-in list (clicking on the worksheet in the list will activate it, your code won't need to do anything more).
Application.CommandBars("Workbook Tabs").ShowPopup