Question: Write a macro called TWOS that finds the value of X: X= 1 + 2 +2 +2+......+2 +22 The result will be displayed to

Write a macro called TWOS that finds the value of X: X= 1 + 2 +2 +2+......+2 +22 The result will be displayed to the user in a message box. Create a button on Sheet1 that executes this macro.

Step by Step Solution

★★★★★

3.36 Rating (162 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

Answer To create a macro in VBA Visual Basic for Applications ... View full answer

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 Programming Questions!

Beauville Furniture Corporation produces sofas, recliners, and lounge chairs. Beauville is located in a medium-sized community in the southeastern part of the United States. It is a major employer in...

The author of the article "Why the Beach Is a Bummer," Roxanne Gay, states her main claim that there's no perfect day at the beach. It has disillusioned many Americans that it's a glamorous place...

You are required to write a Python program that will manage character (heroes and villain) information. Character (hero and villain) information will be stored in a text file that will be read in...

You are creating a Sales order for a customer. The customer wants to observe how prices change as quantities are adjusted. You need to provide an overview of the different price systems available for...

2 On the TicketOrder worksheet, use Trace Precedents to illustrate the formula error in cell B21. Correct the formula in cell B21 by entering the correct cells (the formula should multiply the Number...

My code is not compiling, cannot figure it out. Need help. C++ This is what is should look like: The computer lab is a system that hosts users of several universities computer labs, and allows users...

Suppose Alice wants to send some sensitive information (credit card numbers, SSNs, corporate secrets, health records, invasion orders to start a land war in Asia ) to Bob. To prevent eavesdroppers...

What is the value of $m after this runs? $x = 0; $m = $x++; 0 1 2 2 points QUESTION 2 true || false = false True False 2 points QUESTION 3 What's the output of this code segment? $cost = 102; if...

plz do in python idle Task 1: Creating Simple Functions 1. Open a new Python file and name it "functions_intro.py". 2. Write a function called greet_user ( ) that prints the message "Hello, new...

Visual Basic .NET Project: Determine Poker Hand A poker hand can be stored in a two-dimensional array. The statement: Dim aryintCards(4,14) as Integer (See AryCardExample.xlsx excel spreadsheet)...

PLEASE Include Formulas for each box with the same numbers as the question. Thank you in advance! Sullivan Ranch Corporation has purchased a new tractor and has provided you with the information...

Assume you manage a well-diversified $100 million portfolio of U.S. large capitalization stocks, which is typically as volatile as the S&P 500 Index. You expect your portfolio to earn 6% over the...

Chitukuko ltd produces two types of bed; standard and deluxe in one of its factories. Production capacity is limited to 8,500 machine hours and 5,700 direct labour hours per period. The following...

The cell you are examing appears to have a nucleus. What domain is it apart of ?

As of January 1, 2012, Gammon Corporation had the following balances in its general ledger: a. Collected $42,000 of receivables. b. Accounts Payable as of January 1, 2012, were paid off . c....

The adjusted trial balance of Hanlon Corporation at December 31, 2012, includes the following accounts: Retained Earnings $17,200; Dividends $6,000; Service Revenue $32,000; Salaries and Wages...

Suppose that the owner of Boyer Construction is feeling the pinch of increased premiums associated with workers compensation and has decided to cut the wages of its two employees (Albert and Sid)...

During a jump to his partner, an aerialist is to make a quadruple somersault lasting a time t = 1.87 s. For the first and last quarter-revolution, he is in the extended orientation shown in Figure,...

Figure shows a rigid structure consisting of a circular hoop of radius R and mass m, and a square made of four thin bars, each of length R and mass m. The rigid structure rotates at a constant speed...

Abnormal returns are defined as ____________________Option Athe rise in the price of a stock when a seasoned issue is brought to marketOption Bthe direct costs associated with the issue of preferred...

answer all of question one Question 1 Suppose we have a cylindrical tank with radius r(m) and height h(m). If the tank is being filled with crude oil at flow rate F(m3/min) for a period of time t...

That there are 10 rates but you can't put the whole excel file, the rates are A1 A2 A3 AAA AA1 AA2 AA3 BBB1 BBB2 BBB3 Using the worksheet "Looping", write a macro that deletes all assets (and their...

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 =...

1. Plan and enable a macro. a. Y b. W c. Write out how the macro could be used in a workbook. d. EX 9-Macros in the From the Macro dialog box. Using all of the above. From shortcut key combinations....

*Python 3 Question* In class, we discussed binary representation and how to convert a positive integer value from base 10 (decimal) into base 2 (binary) (or any other base) through repeated division....

*Python 3 Question (I'm sorry, I know it's a long question, but I just wanted to post all of the information I was given)* We discussed binary representation and how to convert a positive integer...