LinkedIn Visual Basic for Applications (VBA)

  Visual Basic for Applications (VBA) assessment linkedin answers

The variable MyVar is declared in a standard module using the Private keyword. Where can a VBA project use that instance of MyVar?

• in any module in the workbook where it is declared
• only in a Type statement in the module where it is declared
• only in the module where it is declared
• only in the procedure where it is declared

Visual Basic for Applications (VBA) assessment linkedin

A VBA project must declare four classes. How many class modules are needed?

• four (one for each class)
• two (one for the properties and one for the methods)
• one (each class is declared in the same module)
• as many as are required by the variable types that the objects return

VBA Linkedin Quiz

You want to declare an object that describes cars, so that your VBA code can apply tests such as the following. What keyword do you use to declare Cars?

If Cars(i).Make="Ford" And Cars(i).MPG > 20 _

     Then Cars(i).Selected = True

• Type
• Variant
• DataFrame
• Object

VBA Linkedin assessment answers

What is the purpose of the .Range("A1:E5").Select portion of this statement?

ActiveCell.Offset(3, 4).Range("A1:E5").Select

• It specifies the range of cells in which the contents of the offset are to be written.
• It specifies the range of cells at which the offset is to be based.
• It provides Resize information—in this case, the offset returns a reference of five rows and five columns.
• It specifies the range that is to be selected after the offset is found.

Linkedin VBA assessment answers

This code is trying to establish a new collection consisting of employee names and numbers. CAssoc is a class. What statement is missing from the code?

Dim Associates As Collection, Assoc As CAssoc, i As Byte

For i = 1 To 200

    Set Assoc = New CAssoc

    Assoc.Name = Cells(i, 1)

    Assoc.Number = Cells(i, 2)

    Associates.Add Assoc

Next i

• Redim(Associates _ (Ubound(Associates)+1))
• Set Associates = Collection
• Redim(Associates(Associates.Count+1))
• Set Associates = New Collection

   VBA Linkedin test

   Linkedin VBA Quiz

   VBA Linkedin learning