Excel VBA editor "Auto List Members" broken

[mintjulep]

The VBA editor has always kindly made suggestions about what methods and properties are available while writing a line of code. For example:

Public Sub Do_Something()
    Worksheets(1).
End Sub

When I type the "." I expect a drop down list of the available objects, methods and properties that could be used here.

This feature is no longer working for me.

This would appear to be controlled from here:

And help tells me that Auto List Members is probably what I want.
Auto List Members: Displays a list that contains information that would logically complete the statement at the current insertion point.

As you can see, it is checked, so I expect it to work.

For reference the feature is working in the Word VBA editor.

Excel for Office 365 MSO (16.0.11328.20362) 32-bit
on Windows 10 Pro version 1709
Recently upgraded from Windows 7

Any suggestions appreciated.

 

[Andrzejek]

[tt]Worksheets[red](1).[/red][/tt] will not give you intelisense, try:

BTW - it is highly encouraged to have this checked:

so you can get [tt]Option Explicit[/tt] at the top of (new) code added auto-magically...


---- Andy

There is a great need for a sarcasm font.

 

[dhookom]

I did a quick search for Excel VBA Intellisense not working and found this.

Duane
Minnesota
Hook'D on Access
MS Access MVP 2001-2016

 

[mintjulep]

Hmm, ok. Maybe my expectations became un-calibrated.

It's my general habit to manually add "Option Explicit". Didn't know there was the option to have it added automagically. Nice.

 

[mintjulep]

@Andrzejek:

How do you get a screenshot with drop down menus still shown?

 

[dhookom]

@mintjulep,
Regarding the screen shot, I'm not sure what Andy uses but Snag-It will do this and more. It's $50 but well worth it if you capture and edit a lot of screens. It will also capture video.

Duane
Minnesota
Hook'D on Access
MS Access MVP 2001-2016

 

[Andrzejek]

>How do you get a screenshot with drop down menus still shown?
With the stuff you already have installed on your computer (no Snag-It)
[ul]
[li]Have on the screen what you want to show[/li]
[li]Hit Alt-PrintScreen (that will capture active window only)[/li]
[li]You can just hit PrintScreen to get everything[/li]
[li]Start Paint[/li]
[li]Ctrl-V to paste what I've captured in Alt-PrintScreen[/li]
[/ul]
I use Paint because of nice drawings of circles, arrows, colors etc.

Did you get your Intellisense working?


---- Andy

There is a great need for a sarcasm font.