Case-Based Critical Thinking Questions
Case 12-2
Your cousin Rebecca knows that you are an experienced VBA programmer so she turns to you for some general guidance when she wants to get started as a programmer herself.
-Rebecca would like to make a reference to the second open Excel workbook window.What do you tell her is the syntax for this?
A) Workbook(2)
B) Open(2)
C) Range(2)
D) Windows(2)

Question

Quizplus · Accepted Answer

The syntax for referencing the second open Excel workbook window is Windows(2). The Windows collection refers to all the open windows in the current instance of Excel, and the index number specifies which window to reference. Therefore, Windows(2) refers to the second open workbook window. The other options listed (Workbook(2), Open(2), Range(2)) do not refer specifically to open workbook windows in the same way that the Windows collection does.