inputting variables in vb macro

Casey · Feb 19th, 2002, 11:40 AM

Hello,
Im trying to create a function to solve linear equations in excel. I have the algorithm, but I need to be able to input 6 variables 2 columns by 3 rows. The first column go in order 1, 2 3 go into x1,x2,x3 as integers, and the second column 1,2,3 go into y1,y2,y3. I just want to be able to select matrix and have the data input into the macro. Im grateful for help
Thanks
Casey

Corni · Mar 18th, 2002, 09:43 PM

Declare an array for three rows and two columns as follows:

Dim VarArray(2,1) As Double

then initialize the elements based on the cells value eg.:

VarArray(0,0)=Cells(r,c).Value

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Feb 19th, 2002, 11:40 AM	#1
Casey Board Regular Join Date: Feb 2002 Posts: 82	Hello, Im trying to create a function to solve linear equations in excel. I have the algorithm, but I need to be able to input 6 variables 2 columns by 3 rows. The first column go in order 1, 2 3 go into x1,x2,x3 as integers, and the second column 1,2,3 go into y1,y2,y3. I just want to be able to select matrix and have the data input into the macro. Im grateful for help Thanks Casey

Mar 18th, 2002, 09:43 PM	#2
Corni Board Regular Join Date: Mar 2002 Location: Brampton Posts: 324	Declare an array for three rows and two columns as follows: Dim VarArray(2,1) As Double then initialize the elements based on the cells value eg.: VarArray(0,0)=Cells(r,c).Value