Force VBA to display currently-selected cells when prompting user to select a range with Inputbox in Excel

Question

I know that I can use Inputbox to prompt the user to select a range

Set rng = Application.InputBox( _
  Title:="Number Format Rule From Cell", _
  Prompt:="Select a cell to pull in your number format rule", _
  Type:=8)

However when this code is executed, the inputbox will initially be empty

How can I make it so that this box will display the currenty-selected cells?

score 2 · Answer 1 · answered Apr 03 '20 at 18:20

2

We can make use of the Default property of the Inputbox method like this:

Set RangeDest = Application.InputBox("Select range to paste onto ", "Obtain Range Object", Selection.Address, Type:=8)

answered Apr 03 '20 at 18:20

Freelensia

402
6
18

To match OP's style: 'Default:=Selection.Address'. – VBasic2008 Apr 03 '20 at 20:50

Force VBA to display currently-selected cells when prompting user to select a range with Inputbox in Excel

1 Answers1