#1: Write a macro to Convert Units from inches to cm and link the macro to a...
Fantastic news! We've Found the answer you've been seeking!
Question:
#1: Write a macro to Convert Units from inches to cm and link the macro to a button to run the code.
#2: Resultant Force and Angle: Using the code, fill in the blue Resultant box with the force and angle. Give instructions on how to run the code
#3:
#4:
#5:
Transcribed Image Text:
Public Function Resultant(vh As Range, vv As Range) As Variant Dim i As Integer Dim Nrows As Integer Dim SumVh As Single Dim sum Vv As Single Dim RF As Single Dim Rtheta As Single Dim Result(2) As Single Nrows = vh.Cells.Count SumVh = 0 sumVv = 0 For i = 1 To Nrows SumVh = SumVh + vh(i) sumVv = sumVv + vv(i) Next i RF = Sqr(SumVh ^2 + sumVv^ 2) 'radians Rtheta Atn(sumVv / SumVh) Rtheta = Atn(sumVv / SumVh) * 180 / 3.1416 'degrees 1 = Result(0) = RF Result (1) Rtheta Resultant Result End Function Public Function Resultant(vh As Range, vv As Range) As Variant Dim i As Integer Dim Nrows As Integer Dim SumVh As Single Dim sum Vv As Single Dim RF As Single Dim Rtheta As Single Dim Result(2) As Single Nrows = vh.Cells.Count SumVh = 0 sumVv = 0 For i = 1 To Nrows SumVh = SumVh + vh(i) sumVv = sumVv + vv(i) Next i RF = Sqr(SumVh ^2 + sumVv^ 2) 'radians Rtheta Atn(sumVv / SumVh) Rtheta = Atn(sumVv / SumVh) * 180 / 3.1416 'degrees 1 = Result(0) = RF Result (1) Rtheta Resultant Result End Function
Expert Answer:
Answer rating: 100% (QA)
Explanation given a question on vba macros for excel please refer to further parts for answers Explanation convert units from inches to cm Go to developer tab and select insert button Press ALT F11 to ... View the full answer
Related Book For
Posted Date:
Students also viewed these programming questions
-
Mercury (SG 13.54) is poured into the tube shown below until it occupies 1 ft of the tube's length. An equal volume of water is then poured into the left leg. Note that the tube has a uniform...
-
In Java for given input of String2510 10 510 10 1 1 1 1 110 5 5 510 5 5 1 1 1 1 110 5 1 1 1 1 1 1 1 1 1 110 1 1 1 1 1 1 1 1 1 1 1 1 1 1 15 5 5 5 55 5 5 5 1 1 1 1 15 5 5 1 1 1 1 1 1 1 1 1 15 1 answer
-
There is no significant difference between male and female infants in the age at which they first walk A pediatrician reviews the age of walking for all infants in her practice and is surprised to...
-
Top executive officers of Preston Company, a merchandising firm, are preparing the next years budget. The controller has provided everyone with the current years projected income statement. Current...
-
A 55-g bullet traveling at 250 m/s penetrates a block of ice at 0C and comes to rest within the ice. Assuming that the temperature of the bullet doesn't change appreciably, how much ice is melted as...
-
Use the data collected in data project 3 of Chapter 2 regarding song lengths. Consider only three genres. For example, use rock, alternative, and hip hop/rap. Conduct an analysis of variance to...
-
Its not like what youve done has really hurt anyone. At most, the missing money might cost earnings-pershare, maybe a penny. Is that what caused you to write those checks in the name of your company?
-
Goltra Clinic is considering investing in new heart monitoring equipment. It has two options: Option A would have an initial lower cost but would require a significant expenditure for rebuilding...
-
A 20 kg dog requires treatment with ketoconazole at 5 mg/kg by oral suspension. The suspension contains 100 mg/5 mL oral solution. What volume does the dog require per dose?
-
Please explain the below WhatsApp architecture diagram how its works and what system architecture its using(parallel, distributed, or hybrid)
-
Answer the questions thoroughly and comprehensively. Why was the trampling of human rights so rampant during martial law? Discuss the silencing of media and freedom of expression during martial law....
-
Read the article "U.S. Supreme Court Case Impacts Social Media and Employment Law." How will this case impact social media and employment law? What are the top 10 social media Legal issues? After...
-
Mass Media Law and Ethics. Ignorance of the law should never be excused. The first Amendment was written in a time where communication was face-to-face or written in a letter. The forefathers could...
-
How can I explain this statement and provide examples? Any tips? Thank you! "Media laws and regulations can be seen as a way to formally enforce agreed upon norms of behavior by government officials...
-
Discuss the media's presentation on crime. What is reported? How accurate are the reports? What impact does it have on crime and fear of crime? 2.Discuss the use of social media in prevention. What...
-
Write 4 comparisons between the relational database and the non-relational database.
-
Ann hires a nanny to watch her two children while she works at a local hospital. She pays the 19 year-old nanny $125 per week for 48 weeks during the current year. a. What is the employers portion of...
-
Multiple jobs can run in parallel and finish faster than if they had run sequentially. Suppose that two jobs, each needing 20 minutes of CPU time, start simultaneously. How long will the last one...
-
Give one advantage and one disadvantage of the registry vs. having individual .ini files.
-
When running on a NUMA machine, whenever the Windows memory manager needs to allocate a physical page to handle a page fault it attempts to use a page from the NUMA node for the current thread's...
-
What are two ratios that measure market value for publicly traded investor-owned businesses?
-
Grandview Clinic has fixed costs of $2 million and an average variable cost rate of $15 per visit. Its sole payer, an HMO, has proposed an annual capitation payment of $150 for each of its 20,000...
-
Part A For each item, identify whether it best applies to lean businesses \((L)\) or traditional businesses \((T)\). 1. Production begins with a sales forecast. 2. Only finished goods are inspected...
Study smarter with the SolutionInn App