Data Types Displayed in Locals Window

Office 2013 and later
GitHub-Mark-64px

Contribute to this content

Use GitHub to suggest and submit changes. See our guidelines for contributing to VBA documentation.

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.

Show: