Solved: Reading data-range from excel workbook

[arrun]

Dear all,

I have created an userform where I want to keep a text-box type place for input of data stored in some open workbook. It should be like, how you select a data range in excel for some regression analysis. Please see the link (http://www.2shared.com/file/11337587...8/snap01.html) of the snap on what I exactly want to have (in red circle). Can anyone please guide me how to read data like that and then pass into some array-variable within some VBA code for further analysis?

Thanks in advance.

[GTO]

Hi there,

Leastwise for me, it would be a lot clearer if you could attach a small wb with the userform and explain what we're trying to do. The pic of the userform is unclear and leaves us guessing at current underlying code.

Thanks,

Mark

[arrun]

Thanks for this mail. Here I am attaching another snap (http://www.2shared.com/file/11347258...91/snap01.html). In that userform1 I have created a Frame within this I want to put a control which let the user to select data from excel file just like ppl select data for regression analysis.

How it is possible?

[arrun]

Please leave my previous message as I was able to do it using "RefEdit"

Anyway thanks for your time