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: Zin AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students

Q

Due to Coriolis Effect, winds in the Northern Hemisphere deflect to the and winds in...

Biology
Q

3 reflection across the y axis Y y X

Geometry
Q

Identify the statement that follows directly from the given condition about x The graph of...

Basic Math
Q

Questic Determine whether each statement is true or false The probability that an event happens...

Statistics
Q

The graph of a function is given Graph the inverse function 7 6 5 44...

Calculus
Q

A linear function is given. Complete parts (a)-(d).h(x) = 1/3 x- 5(a) Determine the slope...

Algebra
Q

Find the solutions by factoring. Choose all that apply.x + 4x = 12Select one or...

Algebra
Q

Linda Blair found the following when carrying out her bank reconciliation:...

Accounting
Q

Part D: Perform ratio analysis. Calculate all applicable ratios to the...

Accounting
Q

Exerclse 13-8A (Algo) T-eccounts and the accounting equation LO 13-1 Required Record each of the...

Accounting
Q

The total factory overhead for Cypress Marine Company is budgeted for the year at $1,171,800,...

Accounting
Q

TRUE OR FALSE 62. Tests of unrecorded assets typically involve tracing from source documents to...

Accounting