Excel VBA Communication & Stakeholder Relations 3

Question 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?

Accepted Answer

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

Answer

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

Question 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?

Accepted Answer

Tools > VBAProject Properties > Protection tab

Answer

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

Question 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?

Accepted Answer

oMail.Attachments.Add ThisWorkbook.FullName

Answer

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

Question 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?

Accepted Answer

Application.DoEvents

Answer

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

Question 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?

Accepted Answer

Application.ScreenUpdating = True

Answer

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

Excel VBA Practice Test

Excel VBA Practice Test

Excel VBA Communication & Stakeholder Relations 3