Question: Please give me the code. Thank you. In your Excel Workbook VBA3 create a new Worksheet named Prob 3.3. Within this Worksheet write a VBA

 Please give me the code. Thank you. In your Excel Workbook

Please give me the code. Thank you.

In your Excel Workbook "VBA3" create a new Worksheet named "Prob 3.3". Within this Worksheet write a VBA program that solve the following problem: Converting polar coordinates (r, theta) to Cartesian coordinates (x, y) is fairly straightforward. Reversing the process is a little bit tricky. The radius calculation is straightforward: r = Squareroot x^2 + y^2 But because of the way arctan is computed the theta may not be correct. While different combinations of x and y will give locations in all four quadrants, typically arctan will give a value in the first or fourth quadrants. Use the following table to correct the calculation to get the correct quadrant. Create a sub named "xytortheta" that: The user enters a x and y via an InputBox. Determines the correct r and theta based on the provided table. Uses a MsgBox to output the correct r and theta

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!