View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_7_] Bob Phillips[_7_] is offline
external usenet poster
 
Posts: 1,120
Default 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