Expand Minimize

Data Types Displayed in Locals Window

Last modified: March 09, 2015

Applies to: Office 2013 | VBA

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:
© 2015 Microsoft