Excel VBA Communication & Stakeholder Relations 4

Question 1

A stakeholder wants your macro to export the summary sheet as a PDF for distribution. Which method saves a worksheet as a PDF in VBA?

Accepted Answer

Sheets("Summary").ExportAsFixedFormat xlTypePDF, "C:\report.pdf"

Answer

ExportAsFixedFormat with xlTypePDF exports the sheet as a PDF to the specified file path.

Question 2

Your macro displays a MsgBox asking stakeholders to confirm before deleting data. Which MsgBox argument combination shows Yes and No buttons and returns vbYes when Yes is clicked?

Accepted Answer

MsgBox "Delete?", vbYesNo returns vbYes

Answer

vbYesNo shows Yes and No buttons, and clicking Yes returns the constant vbYes (value 6).

Question 3

Stakeholders complain that when your macro runs, Excel shows the formula bar and status bar changing rapidly, which is distracting. Besides ScreenUpdating, which property hides status bar messages from your macro?

Accepted Answer

Application.StatusBar = False

Answer

Setting Application.StatusBar = False restores the default status bar text, while setting it to False explicitly clears any macro-set text.

Question 4

A client wants to know when your macro last ran. Which approach stamps the current date and time into a cell each time the macro executes?

Accepted Answer

Range("A1").Value = Now()

Answer

Now() returns the current date and time as a VBA value; assigning it to .Value stores it as a static timestamp.

Question 5

Your stakeholder needs a macro that prompts for a password before granting access to the reporting sheet. Which VBA approach hides typed characters in an InputBox?

Accepted Answer

VBA's standard InputBox does not mask input; use a custom UserForm with a TextBox set to PasswordChar = "*"

Answer

Standard VBA InputBox cannot mask characters; a UserForm TextBox with PasswordChar = "*" is the correct way to accept hidden input.

Excel VBA Practice Test

Excel VBA Practice Test

Excel VBA Communication & Stakeholder Relations 4