VBA: Does not show automatically possible functions

[ineedhalp]

So usually when I write, I get a pop-up with available functions every time I type a .(dot) after the object. It doesn't happen anymore. How can I fix it? Sometimes I forget the function and it takes too long time to search for it, instead of just scrolling down the list and finding the right one. Please halp me fix it. Thanks!

 

[Andrew Poulsom]

In the Visual Basic Editor choose Tools|Options and make sure that Auto List Members is checked on the Editor tab.

 

[Norie]

That could happen for a no of reasons.

For example there might be a problem with references which you can check under Tools>References...

Somehow this functionality has been turned off, you can check that by going to Tools>Options...

On the Editor tab check that Auto List Members hasn't been unchecked and if it has check it.

 

[ineedhalp]

It is checked.

 

[Norie]

Can you post an example of the code where it's not working, including the declaration of any variables used in it?

PS Did you check the references?

 

[ineedhalp]

What should I look for under the references?
hpmh, I found the problem just right now. For example when I use:

Sheets("Main").

Nothing shows up. But using

Sheets.

It shows up. I'm not sure if it was like this all the time or am I just thinking stuff up right now, but I'm pretty sure it used to work even when I used these brackets. Can I somehow still make it possible that it would pop up even when using brackets? It's a pain in the butt to try typing everything out every time just to find the right function, because I don't code in VBA very often

 

[Norie]

It's not supposed to work on that line of code.

 

[Andrew Poulsom]

Intellisense doesn't work for everything, as you have discovered. It will work if you do this:

    Dim ws As Worksheet
    Set ws = Sheets("Main")
    With ws.

 

[cerfani]

Nobody mentioned but if you have syntax errors in your code, it disables auto listing members... comment out or go fix code that might have an error if you havent finished writing other parts of code

For example, I only use VBA time to time so I'm not 100% familiar with all the keywords and I wrote ...

If ~some condition~ Then End Sub 'this is not allowed, I should have wrote, Exit Sub

...that made auto listing members on other parts of my code break

 

[AttemptingVBA]

A reason I found is related to what others above have mentioned. I had Option Explicit within a macro and that is not allowed. It got there because I hit record macro, did things, then stopped the recording. Then I began editing the macro and I put Option Explicit within the macro (below Sub) rather than outside of it (above Sub).

Once I moved it to the correct location then I get the methods and properties back.