I'm wondering how one would go about popping up the list of sheet names that you get when you right click on the arrows on the bottom left (next to the sheet selection) and click "More sheets..." so that I can choose a sheet and have the value returned to the calling function in my VBA code.
InputBox() with a 2nd param of "64" (An array of values) looks promising but I'm very new to VB in Excel and find myself learning best by example
Edit: I've reworked the general idea to make this simpler, I just need to get that Activate sheet dialog up. That's all. In the middle of a VB procedure I'd just like to pop up the dialog that allows me to select a sheet and have the code continue as normal
Thanks
Bookmarks