Enable VBA Auto-Complete in the Excel Visual Basic Editor
Question details
The user wants to enable VBA member suggestions 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.
Open the Excel workbook containing your VBA code. On Windows, you can open the Visual Basic Editor by pressing Alt+F11.
Turn on Auto List Members in the VBA Editor
Enable the Editor option that displays member suggestions for supported VBA objects.
In Excel for Windows, press Alt+F11 to open the Visual Basic Editor.
In the Visual Basic Editor, select Tools > Options, then open the Editor tab.
Select the Auto List Members check box and click OK.
Open a code module and type a supported object name followed by a period to check for member suggestions. Reopen the module if necessary.

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.

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.




