Excel VBA Communication & Stakeholder Relations 2

Question 1

A stakeholder requests that your VBA macro send them an automated email summary after each run. Which Outlook object would you use to create and send the email?

Accepted Answer

Outlook.MailItem

Answer

Outlook.MailItem represents an email message and exposes properties like To, Subject, Body, and the Send method.

Question 2

Your manager wants a pop-up notification when a macro finishes processing. Which VBA statement displays a simple message box with just an OK button?

Accepted Answer

MsgBox "Done!", vbOKOnly

Answer

MsgBox with vbOKOnly displays a dialog with a single OK button, suitable for a simple completion notification.

Question 3

A stakeholder needs your macro to log activity to a shared status cell so others can monitor progress. Which approach writes text to cell A1 on a sheet named 'Log'?

Accepted Answer

Sheets("Log").Range("A1").Value = "Processing..."

Answer

Setting the .Value property of a Range object writes text directly to the specified cell.

Question 4

You need to present a dynamic dashboard to executives and want your VBA macro to automatically refresh all pivot tables before they open the file. Which method refreshes all pivot tables in a workbook?

Accepted Answer

ThisWorkbook.RefreshAll

Answer

ThisWorkbook.RefreshAll refreshes all data connections and pivot tables in the workbook at once.

Question 5

A client asks your macro to display a custom dialog box asking for their project name before running. Which VBA function returns user-typed text from a dialog?

Accepted Answer

InputBox()

Answer

InputBox() displays a prompt dialog and returns the string the user types as its return value.

Excel VBA Practice Test

Excel VBA Practice Test

Excel VBA Communication & Stakeholder Relations 2