Write a VBA code that calculates the total area of the rectangles that can be

created with neighbour $x\text{'}$s in a given $44$ square matrix including $x\text{'}$s and

O$\text{'}$s$.$

$4$ x $4$ square matrix will include only X$\text{'}$s and O$\text{'}$s in an Excel sheet starting

from $A1.$

Example:

When clicked on calculate button, message box should show $48.$

Details of the solution is listed below:

The rectangles with a single square: A$1,$ D$1,$ B$2,$ D$2,$ A$3,$ B$3,$ C$3,$ D$3,$ B$4,$ C$4$

Total area: $10$

The rectangles with $2$ squares: A$3$B$3,$ B$3$C$3,$ C$3$D$3,$ B$4$C$4,$ B$2$B$3,$ B$3$B$4,$

C$3$C$4,$ D$1$D$2,$ D$2$D$3$

Total area: $18$

The rectangles with $3$ squares: A$3$B$3$C$3,$ B$3$C$3$D$3,$ B$2$B$3$B$4,$ D$1$D$2$D$3$

Total area: $12$

The rectangles with $4$ squares: A$3$B$3$C$3$D$3,$ B$3$C$3$B$4$C$4$

Total area: $8$

Notes:

I will test your code with at least $10$ different input sets.

A single square is also a rectangle.

Both width and length of the rectangle can be greater than $1$ unit.

Please show your answer in a message box.