VBA to Prompt for Sheet Name Without Typing

[Larry.LeBlanc@O]

Is there an easy way in VBA to prompt the user to activate the SHEET to be processed, rather than prompting the user to TYPE the name of the sheet?

This code will prompt for the workbook and the range, allowing the user to use the mouse without typing. However, I don't know how to prompt for the SHEET.

Please Login or Register  to view this content.

Thank you!

[Andy Pope]

Doesn't the user select the sheet as well as the range using the Input box?

If so then the MyRange reference can tell you.

Please Login or Register  to view this content.

[Larry.LeBlanc@O]

You are right. The address property of the selected range includes the sheet name, such as '[Wrokbook Name]SheetName'!Range Name

I can search for the ] adn the ' to find the sheet name.

Thanks!

[Andy Pope]

No need to search as the book names is also accessible via the object

Please Login or Register  to view this content.