On Oct 18, 6:07*pm, isabelle wrote:
to recover the address of selected range

Set rng = Application.InputBox(prompt:="Do your selection in the summary page", Type:=8)
Me.TextBox1 = rng.Parent.Name & "!" & rng.Address

--
isabelle

Hi Isabelle,

Thank you for your reply very much!

Your code works. But I am wondering whether I can have two input
fields, one is for users to type in data name, another field is used
to select data range.

Cheers

John