Excel VBA Communication & Stakeholder Relations 5

Question 1

A department head wants to review macro changes before they go live. Which VBA IDE feature lets you step through code one line at a time to demonstrate logic to a stakeholder?

Accepted Answer

F8 (Step Into) in the VBA IDE

Answer

Pressing F8 in the VBA IDE steps through code one line at a time, allowing you to demonstrate execution flow interactively.

Question 2

Your macro must send different email bodies depending on whether a KPI is met. Which VBA structure best models this conditional communication logic?

Accepted Answer

If...Then...Else block assigning different body text

Answer

An If...Then...Else block evaluates the KPI condition and branches to assign the appropriate message body string.

Question 3

Stakeholders need a macro that inserts a formatted table of results into an email body as HTML. Which MailItem property accepts HTML content?

Accepted Answer

.HTMLBody

Answer

The .HTMLBody property of an Outlook MailItem accepts an HTML string, enabling formatted tables, colors, and links in the email.

Question 4

A compliance officer wants every macro run logged with the username and timestamp. Which VBA function returns the current Windows username?

Accepted Answer

Environ("USERNAME")

Answer

Environ("USERNAME") reads the Windows environment variable USERNAME, which always reflects the logged-in OS user.

Question 5

Your macro needs to notify stakeholders only if data in a specific range has changed. Which Excel VBA event fires whenever a cell value changes on a worksheet?

Accepted Answer

Worksheet_Change(ByVal Target As Range)

Answer

The Worksheet_Change event fires whenever a cell value is modified, and the Target parameter identifies which cell(s) changed.

Excel VBA Practice Test

Excel VBA Practice Test

Excel VBA Communication & Stakeholder Relations 5