Question: Please answer the following questions 1-4 by using VBA programing. Screenshot and paste your VBA codes next to your results on Excel worksheet. Please save

Please answer the following questions 1-4 by using VBA programing. Screenshot and paste your VBA codes next to your results on Excel worksheet. Please save your work as a Macro-enabled Workbook, and submit it on Canvas. Reopen your Macro-enabled workbook before you submit to ensure that your VBA programs are correctly saved and workable. Please highlight your final answer in Excel Q1. One of the best-known mathematical formulas is Pythagorean Theorem, which tells us the relationship between the two legs and the hypotenuse in a right triangle. The two legs meet at a 90 angle and the hypotenuse is the longest side of the right triangle and is the side opposite the right angle. The theorem shows that a2+b2=c2, where c is the length of the hypotenuse, and a and b are the lengths of the remaining two legs. Use VBA to create a function with two parameters (i.e., a and b) as the inputs of two legs' lengths, and use Pythagorean Theorem to calculate the length of the hypotenuse. Show the answer when a is 5 and b is 8
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
