I have made a couple tools with setup variables that I wish to keep in Excel and not really accessible to the end user per-se. So I use named ranges. However, rather than type up elaborate setup documents for a spreadsheet – the end user said “can I get a helper routine to fill all these in?”. Yes was the answer ONLY IF we could have the user pick selection ranges. So – using userforms and the Application.InputBox … I think we can! Here’s how…

• Pausing a Macro to Get a User-Selected Range
• Along the path to finding an answer … this is my question …
  • Other common dialogs mentioned in that article

Bingo! JKP Application Development Services is our hero implementing a solution from Peter Thornton. Thanks guys! Scroll down to “Method 2: Use Application.InputBox anyway“