Answered step by step
Verified Expert Solution
Link Copied!

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.

image text in transcribedimage text in transcribed

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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Professional SQL Server 2012 Internals And Troubleshooting

Authors: Christian Bolton, Justin Langford

1st Edition

1118177657, 9781118177655

More Books

Students also viewed these Databases questions

Question

Prepare a short profile of Henry words worth Longfellow?

Answered: 1 week ago

Question

What is RAM as far as telecommunication is concerned?

Answered: 1 week ago

Question

Question 1: What is reproductive system? Question 2: What is Semen?

Answered: 1 week ago

Question

Describe the sources of long term financing.

Answered: 1 week ago