Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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 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 codeStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started