Excel VBA Quality Control & Assurance 4

Question 1

A QA macro must report rows where the value in column C does not match the pattern 'AA-####' (two letters, hyphen, four digits). Which VBA tool handles this?

Accepted Answer

cell.Value Like '[A-Z][A-Z]-####'

Answer

The Like operator with the pattern '[A-Z][A-Z]-####' matches exactly two uppercase letters, a hyphen, and four digits.

Question 2

Which method should a QA macro use to programmatically add a data validation rule to a cell that restricts input to whole numbers between 1 and 100?

Accepted Answer

cell.Validation.Add Type:=xlValidateWholeNumber, Minimum:='1', Maximum:='100'

Answer

The Validation.Add method on a Range object with xlValidateWholeNumber type configures whole-number input restrictions.

Question 3

A QA log workbook must record timestamps for each error found. Which VBA expression returns the current date and time as a single value?

Accepted Answer

Now()

Answer

Now() is the VBA built-in function that returns the current date and time combined as a Date value.

Question 4

To ensure a QA macro handles both 32-bit and 64-bit Excel environments when declaring Windows API functions, which compiler directive is used?

Accepted Answer

#If VBA7 Then ... #Else ... #End If

Answer

The #If VBA7 compiler directive checks for VBA version 7 (Excel 2010+, 64-bit capable) and is the correct conditional for PtrSafe declarations.

Question 5

Which technique allows a VBA QA macro to test a Private Sub in a standard module without changing its access modifier?

Accepted Answer

Use Application.Run 'ModuleName.SubName' from another module

Answer

Application.Run accepts a string with the module and procedure name, allowing external callers to invoke Private procedures by name.

Excel VBA Practice Test

Excel VBA Practice Test

Excel VBA Quality Control & Assurance 4