Modules are just bags of code, intended to be shared between more than one worksheet or object. You can't explicitly place modules into the Objects folder; code that lives there is actually contained ...
How to use VBA’s InputBox function to select a range on the fly in Excel Your email has been sent Often, you’ll want Excel users to specify a range that the app then uses in an automated way.