Logo
Home Study Material Contact Search
AI Chat FREE
  1. computer science
  2. programming
  3. sub hw4_1_1() 'a. using the properties window in t

Sub HW4_1_1() 'a. Using the properties window in the VB editor assign ' the code name wsEx2...

80.2K

Verified Solution

Question

Programming

Sub HW4_1_1()

'a. Using the properties window in the VB editor assign
' the code name wsEx2 to the sheet with tab name Sheet1.
'b. Using VBA code and the code name for worksheet Sheet1,
' make this worksheet the active sheet.
'c. Declare a range variable and assign to this variable
' the range from A2 to A10 in the worksheet Sheet1.
'd. Write VBA code to create a range name and call it“Scores”.
' This range name should refer to the range B6to B14 in
' the worksheet labeled Sheet2
'e. Write VBA code that uses an Excel worksheet function
' that calculates the weighted average score (i.e.,
' the dot product of the range defined in part c. and the range inpart d.
' and place the calculated value in cell A12 of the Sheet1worksheet.
'f. Using VBA code change the background color of cell A12 togreen.
'g. Using VBA code change the font type in cell A12 to italic andbold.
'h. Using VBA code change the format property of cell A12 sothat
' it is displayed as a number with exactly three digits to theright
' of the decimal point and at least three digits to the left of thedecimal point.

End Sub

Answer & Explanation Solved by verified expert
4.1 Ratings (543 Votes)
SolutionVBA CODESub wxEx2 Question b Making the sheet activewsEx2Activate Question c Setting rangeDim r1 Scores    See Answer
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students

Basic Math
1.2K views

A patrol car is parked 50 feet from a long warehouse (see figure). The revolving light...

Biology
1.2K views

Whales communicate with one another using sound. What are the benefits of using sound to communicate...

General Management
1.2K views

At week 24 of a project to shoot a television commercial what should the expenditures be?...

Biology
1.2K views

A targeted and specific change in a gene isa. DNA fingerprintingb. Mutationc. Colony hybridizationd. Site...

Biology
1.2K views

A square has four right.anglesangels

Physics
1.2K views

0 Consider a rectangular slab of length L and area of cross section A A...

Geometry
1.2K views

5 In circle A below AC 1 in and m BAD 70 What is the...

Basic Math
1.2K views

Solve the triangle. Round to the nearest tenth.In ASTR, t = 23, r = 29,...

Basic Math
1.2K views

David has 200 yards of fencing and wishes to enclose a rectangular area.(a) Express the...

Algebra
1.2K views

2 20 pts Look at the table below M Y Y x2 x1 D Number...

Accounting
1.2K views

Evaluate how a bargain purchase option can affect the decision to capitalize a lease

Accounting
1.2K views

Kristie is 67, single and has an adjusted gross income of $25,000. She has no...