Data Types Displayed in Locals Window

This page is specific to the Visual Basic for Applications (VBA) Language Reference for Office 2010.

The following is a list of data types and their default state when they are displayed in the Locals window.

Data Type

Default State

Currency

Value is displayed.

Double

Value is displayed.

Integer

Value is displayed

Long

Value is displayed.

Single

Value is displayed.

String

Value is displayed.

UDT

No value is displayed. Non-editable. Collapsed.

Variant

Value is displayed.

Object

No value is displayed. Non-editable. Collapsed.

Decimal

Value is displayed.

Array

No value is displayed. Non-editable. Collapsed.