Question $1-$ Object Orientated Programming $(10$ marks$)$

Create and save a macro$-$enabled workbook.

Consider the following thick$-$walled cylindrical tube and its properties:

a$.(5$ marks$)$

Setup a worksheet with cells for user to enter values for $r_1,r_2,h,$ and $,$ the density of the material what the cylinder is made by$.$ Also provide cells for cross section area $($CSA$),$ volume $(V),$ mass $(m),$ Area Moments of inertia about $Z(I_Z),$ Area Moments of inertia about $x(I_x),$ Area Moments of inertia about $Y(I_Y),$ which are to be calculated.

All units entered are assumed to be in $mm.$

Add a class module to your project named CylindricalTube.

Add public properties to the class for $r_1,r_2,h,$ and $,$ using appropriate data types.

Add methods to your class to calculate CSA, $V,m,I_Z,I_x,$ and $I_Y$ which must be returned with a result based on the milli$-$meters unit.

$1$

Formula:

CSA $=r_2^2-r_1^2$

$V=h{r}_2^2-h{r}_1^2$

$m=h{r}_2^2-h{r}_1^2$

$I_Z=\frac{1}{2}m(r_2^2+r_1^2)$

$I_x=\frac{1}{12}m[3(r_2^2+r_1^2)+4h^2]$

$I_Y=\frac{1}{12}m[3(r_2^2+r_1^2)+4h^2]$

b$.(5$ marks$)$

Add an Active$-$X or form button with caption "Calculate" to your worksheet which executes code using the CylindricalTube object. When clicked the code will create a new instance of the CylindricalTube object and assign values to the new object properties for $r_1,r_2,h,$ and $$ from the spreadsheet, then using methods, populate cells containing CSA, $V,m,I_Z,I_x,$ and $I_Y.$

Your worksheet should look something like this: