Getting the user to pick an Excel cell range via a dialog …
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 …
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“