Visual Basic for Applications (VBA) Test

Visual Basic for Applications (VBA) assessment linkedin

When can a Worksheet_Change event be triggered?

• when a formula recalculates and its result changes
• when the user changes a value on the worksheet
• when the user changes the worksheet's name
• when the user changes the format of a cell on the worksheet

Visual Basic for Applications (VBA) assessment linkedin answers

There are two references that must be selected in the Visual Basic Editor in order for any Visual Basic code to run in Excel. What are these two references?

• VBA and MS Office object library
• MS Excel object library and MS Office object library
• VBA and Excel object library
• MS Excel object library and OLE automation

VBA Linkedin assessment answers

What unconditionally pauses the execution of VBA code?

• Step Into command
• Set Next Statement command
• a breakpoint
• End statement

VBA Linkedin test

Which directive must be set in order to specify the default member of a class?

• Attribute
• Interactive
• Interface
• Extensibility

VBA Linkedin Quiz

How do you indicate that a line of VBA code is a comment?

• Insert an underscore (_) immediately to the left of the comment.
• Insert an uppercase C as the line's first character.
• Insert a single quotation mark (') immediately to the left of the comment.
• Insert a number sign (#) as the line's first character.

  Linkedin VBA assessment answers

  Linkedin VBA Quiz

  VBA Linkedin learning