Question

Please I need Visual Basic code with Excel sheet

Develop a general VB code that can compute the determinant of a 3 x 3 matrix (input the matrix values

from cells in the spreadsheet) using the method we discussed in class. Have your program use cofactor

expansion, expanding about the members in the second row (if you want to expand about some other row or column later for your own personal use, that’s fine, but for this program, expand about the second row). Remember to use the (-1)i+j scheme to get the correct signs. Test your program by computing the determinant of a 3 x 3 matrix that you make up. Show the computation of the determinant by hand calculation and compare the answer to the answer you get with your program (i.e., provide a picture or scan of your hand calculation with your homework).

Answer 1

Option Explicit
Option Base 1
Private Sub CommandButton1_Click()
Dim i As Integer, j As Integer
Dim A(3, 3) As Single, detA As Single
'Input Matrix A
For i = 1 To 3
   For j = 1 To 3
       A(i, j) = Cells(i + 1, j)
   Next j
Next i
'Calculation of matrix determinant
detA = (-1) ^ (2 + 1) * A(2, 1) * (A(1, 2) * A(3, 3) - A(1, 3) * A(3, 2))
detA = detA + (-1) ^ (2 + 2) * A(2, 2) * (A(1, 1) * A(3, 3) - A(1, 3) * A(3, 1))
detA = detA + (-1) ^ (2 + 3) * A(2, 3) * (A(1, 1) * A(3, 2) - A(1, 2) * A(3, 1))
'ouput
Cells(6, 2) = detA
End Sub