Yashraj Jadhao
New Member
- Joined
- Nov 14, 2021
- Messages
- 9
- Office Version
- 2021
- Platform
- MacOS
Insert a button into your sheet now with the button label saying “Multiply Matrixces A*B” which when
pressed runs a macro named MatrixMultiply that uses a “nested” FOR loop structure to multiple the
two 3x3 matrices entered by the user in the two sets of yellow cells and report the matrix product in
the green cells. Your macro should check to make sure that there are numbers in all 18 yellow cells
before it tries to multiply the matrices and if any of the cells in yellow are blank and missing a number
the macro should just print a message to the user in the empty cell by filling it with the text “EMPTY”,
then display a MsgBox() that states “Error, one or more of the entries in the A or B matrix was empty.”,
and then stop the macro.
pressed runs a macro named MatrixMultiply that uses a “nested” FOR loop structure to multiple the
two 3x3 matrices entered by the user in the two sets of yellow cells and report the matrix product in
the green cells. Your macro should check to make sure that there are numbers in all 18 yellow cells
before it tries to multiply the matrices and if any of the cells in yellow are blank and missing a number
the macro should just print a message to the user in the empty cell by filling it with the text “EMPTY”,
then display a MsgBox() that states “Error, one or more of the entries in the A or B matrix was empty.”,
and then stop the macro.