For this assignment, you will create a macro$-$enabled Excel workbook that performs matrix multiplication

of two randomly generated matrices, where the dimension of each matrix is specified by the user. Your

sub must meet the following specifications:

a$)$ Your workbook will have one sheet named "matrixMult"

b$)$ You will clearly designate an area on this worksheet $($through appropriate formatting$)$ where the

user can input the dimensions of two matrices $($see snippet below for example$).$ For the purpose of

this assignment, we will assume that the user always inputs valid dimensions. Recall that two

matrices can be multiplied if the number of columns of the first matrix are equal to the number

rows in the second matrix. For example:

matrix$1$: $42(4$ rows, $2$ cols$),$ matrix$2$: $26(2$ rows, $6$ cols$),$

when multiplied $($matrix$1$ matrix $2),$ the results will be a $46$ matrix

Note that the number of columns in the first matrix $(2$ cols$)$ must be equal to the number of

rows in the second matrix $(2$ rows$)$ in order to perform matrix multiplication

If this condition is not met, the matrices cannot be multiplied

c$)$ Create a single sub named "mmult" in VBA.

d$)$ This sub will read the appropriate dimensions from the worksheet $($assume that the user always

inputs the dimensions in the correct spot$-$because you've clearly designated this area on your

worksheet$-$and that the dimensions are always valid for matrix multiplication$).$

e$)$ Using these user$-$defined dimensions, you will then generate two matrices with these dimensions,

where each value in the matrix is a random integer between $1,10.$

The upper left corner of the first matrix must be in the same row as your matrix$1$ user input

cells, two columns to the right from the user input cells.

The upper left corner of the second matrix must be in the same row as the upper left corner

of matrix $1,3$ columns to the right of the last column in matrix$1.$

In your vba code, access the worksheet function RANDBETWEEN$()$ to generate a random

c$)$ Create a single sub named "mmult" in VBA.

d$)$ This sub will read the appropriate dimensions from the worksheet $($assume that the user always

inputs the dimensions in the correct spot$-$because you've clearly designated this area on your

worksheet$-$and that the dimensions are always valid for matrix multiplication$).$

e$)$ Using these user$-$defined dimensions, you will then generate two matrices with these dimensions,

where each value in the matrix is a random integer between $1,10.$

The upper left corner of the first matrix must be in the same row as your matrix$1$ user input

cells, two columns to the right from the user input cells.

The upper left corner of the second matrix must be in the same row as the upper left corner

of matrix$1,3$ columns to the right of the last column in matrix$1.$

In your vba code, access the worksheet function RANDBETWEEN$()$ to generate a random

integer between $1$ and $10$ in each of the cells of the two matrices.

At this point, you should have two matrices written to the excel worksheet that each reflect

the dimensions input by the user, and each cell is a random integer between $1$ and $10.$

f$)$ Next, you will perform matrix multiplication of these two matrices, and the resulting matrix will be

written the excel sheet where the upper left corner of this resulting matrix will be in the same

column as the upper left corner of matrix$1,$ and $3$ rows below the last row of matrix$1.$

You cannot use the MMULT worksheet function for your matrix multiplication.

Your subroutine should include the necessary looping to multiply the appropriate elements

of each matrix to generate the resulting value for each cell of the final matrix.

Recall matrix multiplication: $($see Wikipedia page for further background if desired$)$

$\left[\begin{array}{ccc}{a}_{11}& a_{12}& a_{13}\\ a_{21}& a_{22}& a_{23}\end{array}\right]\left[\begin{array}{cc}{b}_{11}& b_{12}\\ b_{21}& b_{22}\\ b_{31}& b_{32}\end{array}\right]=\left[\begin{array}{cc}{a}_{11}**b_{11}+a_{12}**b_{21}+a_{13}**b_{31}& a_{11}**b_{12}+a_{12}**b_{22}+a_{13}**b_{32}\\ a_{21}**b_{11}+a_{22}**b_{21}+a_{23}**b_{31}& a_{21}**b_{12}+a_{22}**b_{22}+a_{23}**b_{32}\end{array}\right]$

g$)$ I encourage you to check your work. You can use a quick check on the excel worksheet using the

MMULT$()$ worksheet function to ensure your results match. Or you can use any other tool to verify

the accuracy of your results as you build your matrix multiplication sub.

h$)($this part is not required, but is useful$)$ As you are building your solution, it might help to create a

clear$()$ sub, that you can quickly run to clear the contents of the excel sheet where you are

generating your matrices. A quick way to do this is to just clear a large chunk of columns to the

right of your user input $($this way, it will likely work for any matrix dimensions that the user inputs.

For example:

Sub clear$()$

Range$("$G:Z$").$clear

End Sub