Excel VBA Technology & Digital Applications 4

Question 1

Which VBA class provides access to the Windows Registry for reading and writing keys?

Accepted Answer

WScript.Shell via RegRead/RegWrite

Answer

The WScript.Shell object exposes RegRead, RegWrite, and RegDelete methods for interacting with the Windows Registry from VBA.

Question 2

In VBA, what keyword prevents a variable declared in a standard module from being accessed by other modules?

Accepted Answer

Private

Answer

Private restricts the variable's scope to the module in which it is declared, hiding it from all other modules.

Question 3

Which Excel object model property returns a Range representing all cells currently visible after applying filters?

Accepted Answer

Range.SpecialCells(xlCellTypeVisible)

Answer

SpecialCells(xlCellTypeVisible) returns only the cells that are not hidden by row/column hiding or AutoFilter, enabling operations on filtered data.

Question 4

When using ADO in VBA to query an Excel workbook as a database, which connection string provider is used?

Accepted Answer

Microsoft.ACE.OLEDB.12.0

Answer

The ACE OLEDB 12.0 provider supports .xlsx files; the older Jet 4.0 provider only supports .xls files.

Question 5

What VBA property of a Chart object allows you to programmatically change its chart type?

Accepted Answer

Chart.ChartType

Answer

The ChartType property accepts an XlChartType enum constant (e.g., xlLine, xlBar) to change the chart's visualization type.

Excel VBA Practice Test