VBA & Macro Problems

Enable VBA Auto-Complete in the Excel Visual Basic Editor

Khadija KhanKhadija Khan Nov 18, 2026 870 views

Question details

The user wants to enable VBA member suggestions in the Excel Visual Basic Editor.

Enable VBA Auto-Complete in the Excel Visual Basic Editor
Product
Microsoft Excel Visual Basic Editor
Device & OS
not provided
Scenario
Writing VBA code in an Excel workbook and using IntelliSense to find available object members.
Observed behavior
The desired result is for supported VBA object members to appear as suggestions while typing.
Before you start

Open the Excel workbook containing your VBA code. On Windows, you can open the Visual Basic Editor by pressing Alt+F11.

Solution 1Recommended

Turn on Auto List Members in the VBA Editor

Enable the Editor option that displays member suggestions for supported VBA objects.

1
Open the Visual Basic Editor

In Excel for Windows, press Alt+F11 to open the Visual Basic Editor.

2
Open the editor options

In the Visual Basic Editor, select Tools > Options, then open the Editor tab.

3
Enable member suggestions

Select the Auto List Members check box and click OK.

4
Test the setting

Open a code module and type a supported object name followed by a period to check for member suggestions. Reopen the module if necessary.

Turn on Auto List Members in the VBA Editor
Suggestions depend on the object: The editor can show members when it can determine the object's type; suggestions are not available for every expression.
Free Microsoft Office alternative

Work with Excel Spreadsheets in WPS Office

WPS Office is a free, lightweight alternative with a familiar interface for opening and editing spreadsheets. Its Excel format compatibility helps you move existing files into your workflow. It does not change settings in Excel's Visual Basic Editor.

Open and edit Microsoft Excel XLSX and XLS filesUse a familiar spreadsheet interface for everyday workbook editingMove existing Excel files into a lightweight office suiteWork with spreadsheets for free
microsoft office alternative - wps office

Frequently Asked Questions

Where is Auto List Members in Excel?

Open the Visual Basic Editor, then select Tools > Options > Editor. Select the Auto List Members check box and click OK.

How do I open the VBA editor in Excel?

In Excel for Windows, press Alt+F11 to open the Visual Basic Editor.

Why don't suggestions appear for every VBA object?

Member suggestions depend on whether the editor can determine the object's type. Check Auto List Members under Tools > Options > Editor, and test with a supported object followed by a period.

What should I do if suggestions still don't appear after enabling the option?

Click OK in the Options dialog, reopen the code module, and test a supported object by typing its name followed by a period.