Question: I need help writing a VBA code in excel. I need the code to start with Option Explicit and I need to do the following:

I need help writing a VBA code in excel. I need the code to start with Option Explicit and I need to do the following:

Solutions to ax^2+bx+c=0

- Prompt the user for a,b, and c

- Calculate the roots of the equation ( x= -b +/- sqrtb^2-4ac/2a)

- Report values of a, b, c, and the two roots to the worksheet

- Be sure to consider the case of an imaginary root - then enter "No real solution" in the worksheet

- If thee is no real solution, enter the imaginary solution (eg. 3 + 4i) in the worksheet.

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!

Q:

I have the flow chart, need help with the VBA code OKC Tours Programming Project Assume you have just been hired by the manager of OKC Tours (OKCT), a small company located in Oklahoma City. OKCT...

Q:

Hello, I am making a guessing game in excel. I have completed the construction of the basic framework ( such as text box settings, start and end button settings ) but have not completed writing the...

Q:

Hello, I am making a guessing game in excel. I have completed the construction of the basic framework ( such as text box settings, start and end button settings ) but have not completed writing the...

Q:

Liting Wang Shelly Cashman Excel 2013 Chapter 10: SAM Project 1a Submission #2 Score is 79 out of 100 1. Go to the Event Schedule - 2018 worksheet and use the password J@Nuary18 to unprotect the...

Q:

PROJECT DESCRIPTION Patrick Fitzgerald is the director of Career Development at Finn Technical Institute, a local community college. The Institute offers workshops on resume writing, interview...

Q:

Link to the data if you need to see how the program works (look for specific sheet shown in instructions):...

Q:

Background Information This assignment tests your understanding of and ability to apply the programming concepts we have covered throughout the unit. The concepts covered in the second half of the...

Q:

Instructions for Preparing the Assignment Deliverables: This homework consists of writing two programs, Okc Tours and Calories to Burn . Write both codes in the same excel document. 1. Visual Basic...

Q:

Need help with this cost and benefit problem. Please follow the instruction to solve the table question.(just draw the table in the excel first in the instruction, then write down the memo for one...

Q:

in excel using developer 1. (4 points) Open a workbook, get into the VBE, insert a module, and enter the following code: Public Sub NowYouSeeMe0 Dim myName as String, nMiles as Integer yourName =...

Q:

Those of you who are skiers or snowboarders know that some resorts have "high-speed" chair lifts. These lifts are called "detachable" because the chair detaches from the main cable just before...

Q:

Show that the last sentence of the preceding paragraph is correct.

Q:

2 5 . Stephanie purchased a corporate bond that matures in three years. The bond has a coupon interest rate of 9 percent and its yield to maturity is 6 percent. If market interest rates remain...

Q:

AbnerCorporation's bonds mature in22 years and pay11 percent interest annually. If you purchase the bonds for$1,200, what is your yield tomaturity? Your yield to maturity on the Abner bonds...

Q:

=+2. What does it mean for an organization to be ethical? What is the difference between an unethical and an illegal act?

Q:

=+2. Should the armed services have to answer to CNN or any other news organization? Isnt that the responsibility of the civilian planners and politicians that shape the strategies that the armed...

Q:

=+4. An important component of implementing an ethical or CSR perspective organization wide is consistency across departments. Do you feel that the lessons you are learning in this class are...