Question: Can someone help me write this in VBA for Microsoft Excel. If you could include screenshot of the test run. That would be really appreciated.

 Can someone help me write this in VBA for Microsoft Excel.If you could include screenshot of the test run. That would be

Can someone help me write this in VBA for Microsoft Excel. If you could include screenshot of the test run. That would be really appreciated. Thank You!!

3. write a macro to solve the following problem. If the interest rate of an account it 7.5% per year and your initial deposit is $10,000 how much money will you have after 24 months if the bank decides to compound the interest continuously. In the formula below A is the future amount, P is the principal or starting amount, r is the interest rate (in decimal form) and t is time in years. You will need to look up the syntax to enter "e" in VBA Add a button to your excel sheet that will allow a user to run the code you create. . Use input boxes to as the user for the needed information (they will enter exactly what is given in the problem statement so you will need to perform any needed conversions in the code) Report the answer in a message box that says future amount-(your answer) Hint get your code running by directly entering the values for the variables in your code. Once you know it works then replace this with input boxes. This will avoid having to enter the data every time you want to test your code

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!