Expand Minimize

Data Types Displayed in Locals Window

Last modified: December 06, 2011

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