Question: Write a code to provide the total number of students enrolled in each Major. The user will provide the Major name using an inputbox and

Write a code to provide the total number of students enrolled in each Major. The user will provide the Major name using an inputbox and the message with the result should arrive in a MsgBox. The names of the majors are located in range("D2:D121'). Using VBA code

Step by Step Solution

★★★★★

3.38 Rating (154 Votes )

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

Write an SQL query to determine the total number of hours and the total number of lessons Tutor 106 taught in June and July 2015.

Using the data set agsrs.dat, estimate the total number of acres devoted to farming for each of two domains: (a) Counties with fewer than 600 farms, and (b) Counties with 600 or more farms. Give...

The following data represent the total number of U.S. households, the number of households headed by women, and family size from 1960 to 1990. Present these data in a way that reveals any changes in...

Write a program that enables the user to input name, address and local phone number, including area code. The phone number should be entered in a format to include dashes between the numbers (i.e....

Soloman Academy, is a profit-oriented education business. Soloman provides remedial training for high school students who have fallen behind in their classroom studies. It charges its students $500...

Peabody Academy is a profit-oriented education business. Peabody provides remedial training for high school students who have fallen behind in their classroom studies. It charges its students $650...

Apple Academy is a profit-oriented education business. Apple provides remedial training for high school students who have fallen behind in their classroom studies. It charges its students $750 per...

1. In the United States, the total number of students enrolled in public schools is 49,373,000. There are 98,817 public schools. Write a unit rate in students per school. Round to the nearest whole....

Use any strategy to solve each problem Examples 1 and 2 1 Yolanda s club requires that 80 of the members be present for any vote If at least 20 members must be present to have a vote how many members...

A college offers tutoring in Math, English, Chemistry, and Biology. The number of students enrolled in each subject is listed below. The college can only afford to hire 19 tutors.Using...

What do health plans use claims data for? A. To determine costs of care, future investment strategies, and payment for healthcare location. B. To track diseases and illnesses nationwide,...

The following fact pattern applies to questions 1 and 2. Brigid entered into a contract with L. Marcus Marine ("LMM") to perform repairs and updates to her sailboat for $15,000. The work was to be...

An SLA manager compares the usage of a system against: Question 1Select one: a. A pay-per-use measurement repository b. An SLA monitor agent c. A quality-of-service measurement repository d. A...

an 1800 kg vehicle travelling at 60.0km/h smashes into a concrete barrier and stops in 0.420s what is the magnitude of the collision force on the vehicle

Flo's Deli is determining how to ensure that their current process of serving customers during lunch rush is adequate. Which of the following is an example of how the restaurant can monitor its...

Suppose that Gyp Sum Industries currently has the balance sheet shown below, and that sales for the year just ended were $ 1 0 million. The firm also has a profit margin of 2 5 percent, a retention...

The water in tank A is at 270 F with quality of 10% and mass 1 lbm. It is connected to a piston/cylinder holding constant pressure of 40 psia initially with 1 lbm water at 700 F. The valve is opened,...

Explain how the volatility of a data warehouse is different from the volatility of a database for an operational information system.

What is XSLT, and how does it differ from XML? What role does it play in the creation of a Web application?

Does a data modeling project using a packaged data model require less or greater skill than a project not using a packaged data model? Why or why not?

=+4. Citrus products must have a certain sugar content, measured in degrees Brix, to be judged satisfactory to sell to grocery stores. Suppose that a certain batch of oranges fails to meet the...

=+5. Measurements are to be taken on each of the following characteristics. In each case, indicate whether the resulting measurements would be classified as variables or attributes data.

=+c. What percentage of these measurements falls above the USL? What percentage of the measurements falls below the LSL?