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.
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.