PDA

View Full Version : Solved: Reading data-range from excel workbook



arrun
02-12-2010, 01:13 PM
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/37b264d8/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
02-12-2010, 01:50 PM
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
02-13-2010, 12:56 AM
Thanks for this mail. Here I am attaching another snap (http://www.2shared.com/file/11347258/a5cccd91/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
02-13-2010, 01:30 AM
Please leave my previous message as I was able to do it using "RefEdit"

Anyway thanks for your time