Use Visual Basic for Applications with Excel to answer the following question:

Save your work as an Excel macro$-$enabled workbook and upload to moodle $($you do not need to upload the word document$).$

Question $1-$ Visual Basic for Applications Programming $(10$ marks$)$

Create and save a macro$-$enabled workbook.

Consider a simply fixed$-$fixed beam of length $L$ with uniformly distributed load $($UDL$)w.$ The beam is of rectangular section of $b,$ height $h$ and modulus $E.$