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 stakeholder wants your macro to export the summary sheet as a PDF for distribution. Which method saves a worksheet as a PDF in VBA?

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

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

  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?

    Answer: MsgBox "Delete?", vbYesNo returns vbYes

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

  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?

    Answer: Application.StatusBar = False

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

  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?

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

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

  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?

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

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

  6. You want your VBA report macro to CC the CFO automatically on all generated emails. Which Outlook MailItem property sets the CC recipients?

    Answer: .CC = "cfo@company.com"

    The .CC property on a MailItem accepts a semicolon-delimited string of email addresses for carbon-copy recipients.

  7. A stakeholder finds your macro hard to use because it offers no progress indication during a long loop. Which technique updates a status message in the Excel status bar during processing?

    Answer: Application.StatusBar = "Processing row " & i & " of " & total

    Setting Application.StatusBar to a string displays it in Excel's status bar without interrupting macro execution.