Hi all,

I want to write a Sub which takes a cell range as an input. I want the
user to selsect this input each time the macro is run. So I want an
input box which tracks the cells selected after the box has popped up,
JUST LIKE the one used for selecting input range for Chart Wizard.

What is it called, if it even exists?

Further, is there a webpage which shows the names of all the VBA
components against their names.

Cheers,

Rory

You can use Application.Inputbox with a type 8

Dim rng As Range
Set rng = Application.Inputbox("Select a range",Type:=8)
If Not rng Is Nothing Then
...

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Kidaz" wrote in message
ups.com...
Hi all,

I want to write a Sub which takes a cell range as an input. I want the
user to selsect this input each time the macro is run. So I want an
input box which tracks the cells selected after the box has popped up,
JUST LIKE the one used for selecting input range for Chart Wizard.

What is it called, if it even exists?

Further, is there a webpage which shows the names of all the VBA
components against their names.

Cheers,

Rory

Thanks, thats awesome. It works perfectly!

Rory