Excel VBA Quality Control & Assurance 2

Question 1

Which VBA approach best validates that a user-entered date falls within a fiscal year range before processing?

Accepted Answer

Use IsDate() to confirm it's a date, then compare the value to fiscal start/end date variables

Answer

IsDate() confirms the value is a valid date before numeric date comparisons are made against fiscal boundary variables.

Question 2

A QA macro must abort and log an error if a required worksheet named 'Data' is missing. Which code pattern is correct?

Accepted Answer

On Error Resume Next: Set ws = Sheets('Data'): On Error GoTo 0: If ws Is Nothing Then GoTo ErrLog

Answer

Using On Error Resume Next lets VBA attempt the assignment; if the sheet is missing, ws remains Nothing, triggering the error branch.

Question 3

When auditing cell formulas in a QA macro, which property returns the formula string of a cell?

Accepted Answer

Cell.Formula

Answer

Cell.Formula returns the formula as entered in A1 notation, suitable for string inspection in QA routines.

Question 4

A QA sub needs to flag all cells in column B that contain negative numbers. Which loop construct is most appropriate?

Accepted Answer

For Each cell In Columns('B').SpecialCells(xlCellTypeConstants, xlNumbers)

Answer

SpecialCells(xlCellTypeConstants, xlNumbers) restricts the loop to cells with numeric constants, avoiding blank/formula cells and improving performance.

Question 5

Which VBA statement writes a QA error message to the Immediate Window without halting execution?

Accepted Answer

Debug.Print 'Error: ' & msg

Answer

Debug.Print outputs text to the Immediate Window at runtime without pausing or stopping the macro.

Excel VBA Practice Test

Excel VBA Practice Test

Excel VBA Quality Control & Assurance 2