VBA does not show the options and Methods automatically

Question

I’m new here, and I apologize for the "banal" doubt, but I’ve been researching this for a long time.

I use the VBA by EXCEL, and I can’t activate the option of the text if self-prefill when writing a known function or method.

Thus, I have had great difficulty in knowing the methods that a certain object possesses. I’ve already activated Autocheck Syntax and other options:

So my question is: I need to add some specific extension to that, or just enable something I’m not finding?

Thank you for your attention.

Answer 1

That is the option Autolistar membros, which is marked on the print you sent.

One option to do this manually is to right-click and select Listar propriedades/métodos, but it’s so cool to do it by hand:

But here’s the thing: if you’re trying to use this with an object that’s part of an unregistered library, it won’t show up at all. Try with ThisWorkbook., that integrates the Excel library itself, and see if appears.

If it doesn’t show up, there’s some deep configuration lost there, besides my answer.