Thanx....i didnt mean any offence to any1....hope we're cool....lol...i 'll take ur advice on board especially what u gave me earlier and i'll holla if i have any more problems...Than x 4 ur time..x...

Hi Kad..i know am being a bad girl...lol...an d i'm not supposed 2 get help but i only need a push in d right direction and i'll be able to take it from there..cos i've neva done VB b4 and i've jst been kinda pushed in2 it and i'm faced with a lot of obstacles.....i fink i shud b able 2 giv it a go now from ur help...thanx a lot....really sorry if i offeded any1...x...

Hi thanx 4 d reply,i was going 2 use the macro recorder but i'm not allowed to,i'll av 2 write d code from start myself and thats where i'm stuck,i've tried wikipedia but i havent had much help from dat either as i'm not able 2 apply d formulas in2 writing a code but i'm giving it a try....pls any more help would b appreciated..th anx..x

Hi every1,this is my 1st time using this forum....pls can any1 tell me how to create a code in VB that can do LINEAR REGRESSION in excel.....i'm not sure how to xplain exactly what i need but basically you know when u use the data analysis tool for regression in excel and it outputs the intercept,anova ,residuals e.t.c.,basicall y i need to be able to do a code in VB that can calculate all dis(linear regression) using the data that i have and output...