EnableAutoComplete Property [Excel 2007 Developer Reference]

Switch View :
ScriptFree
Application.EnableAutoComplete Property
True if the AutoComplete feature is enabled. Read/write Boolean.

Syntax

expression.EnableAutoComplete

expression   A variable that represents an Application object.

Example

This example enables the AutoComplete feature.

Visual Basic for Applications
Application.EnableAutoComplete = True