Taking range as input from the User
 

Hi all,

I am trying to immitate the Excel's feature of taking input range from
user. I have a predefined graph type and I would like user to choose
upto 3 ranges so that I can use those ranges for plotting the graph.

Can anyone suggest me if there is any good way to do that.

Thanks


--
jn_mohit
------------------------------------------------------------------------
jn_mohit's Profile: http://www.excelforum.com/member.php...o&userid=25030
View this thread: http://www.excelforum.com/showthread...hreadid=385574

Taking range as input from the User
 

User Application.Inputbox with a Type value of 8.

--
HTH

Bob Phillips

"jn_mohit" wrote in
message ...

Hi all,

I am trying to immitate the Excel's feature of taking input range from
user. I have a predefined graph type and I would like user to choose
upto 3 ranges so that I can use those ranges for plotting the graph.

Can anyone suggest me if there is any good way to do that.

Thanks


--
jn_mohit
------------------------------------------------------------------------
jn_mohit's Profile:
http://www.excelforum.com/member.php...o&userid=25030
View this thread: http://www.excelforum.com/showthread...hreadid=385574