Practice Test GeeksExcel VBA Practice Test
← All Excel VBA Flashcard Decks

Communication & Stakeholder Relations Flashcards

7 cards from real Excel VBA practice questions. Tap to flip, then mark Knew It or Still Learning — missed cards come back until you master them.

Read the first 7 Communication & Stakeholder Relations flashcards as text

  1. A project manager wants your VBA tool to automatically add comments to cells flagging issues so reviewers can see them. Which method adds a comment to a cell in VBA?

    Answer: Range("A1").AddComment "Review this value"

    The AddComment method on a Range object inserts a new comment with the specified text.

  2. You are building a VBA tool for non-technical stakeholders. To prevent accidental macro modification, you should protect the VBA project with a password. Where is this setting found in the VBA IDE?

    Answer: Tools > VBAProject Properties > Protection tab

    In the VBA IDE, Tools > VBAProject Properties > Protection tab lets you lock the project and set a password.

  3. A stakeholder wants to receive a weekly Excel report generated by your macro via email with the workbook attached. Which code snippet correctly attaches the active workbook to an Outlook email?

    Answer: oMail.Attachments.Add ThisWorkbook.FullName

    The Attachments.Add method accepts a file path, and ThisWorkbook.FullName provides the complete path including filename.

  4. To make your macro's status updates visible in real time while it runs (instead of only after it finishes), which Application method should you call periodically?

    Answer: Application.DoEvents

    Application.DoEvents yields control to the Windows event loop, allowing the screen to refresh and the UI to respond during long macro runs.

  5. Your team lead asks why cell updates in your macro aren't visible until the macro ends. You explain you disabled screen updating for performance. Which line re-enables it?

    Answer: Application.ScreenUpdating = True

    Application.ScreenUpdating = True re-enables live screen refresh after it was turned off for performance.

  6. A stakeholder wants the VBA macro to create a hyperlink in a cell that, when clicked, opens their team's SharePoint site. Which method inserts a hyperlink in VBA?

    Answer: ActiveSheet.Hyperlinks.Add Range("A1"), "https://sharepoint.com/team"

    ActiveSheet.Hyperlinks.Add takes an Anchor range and an Address string to insert a clickable hyperlink.

  7. You want your macro to notify stakeholders of an error without crashing the tool. Which VBA construct lets you handle runtime errors gracefully and show a user-friendly message?

    Answer: On Error GoTo ErrorHandler with a labeled error routine

    On Error GoTo with a labeled handler block lets you catch errors and display a meaningful message before exiting cleanly.