No Intellisense for "Sheets" Object in Excel VBA?

[Jesus_Loves]

In Excel VBA . . . The the Intellisense / auto-complete feature will not activate for the Sheets object



Sub Test()


Sheets(1).Select ' Sheets(1). intellesense does not work on this line

Range("A23").Select ' Range("A23"). intellesense works perfectly on this line

End Sub




The Sheets object (Excel) has several properties and methods that should Intellisize (see url below)

https://docs.microsoft.com/en-us/office/vba/api/excel.sheets

Does anyone know why the Sheets object's intellisense doesn't work?

[Aussiebear]

Have you checked the Preferences section to make sure the intellisense check box is enabled?

[Jesus_Loves]

I can't seem to find this one. How would I navigate to <Preferences..><Intellisense..> options??

Edit.. Also meant to ask. . .
Do you see the Intellisense for the Sheets object? I get Intellisense for so many others Objects but not for the Sheets

[Jesus_Loves]

I found this one from within the VBA IDE <Tools><Options>

Where I have <Auto List Members> checked. Is this the same one you're referring to?

[snb]

Just hope and pray.....

[Jesus_Loves]

Just hope and pray.....

That put a smile on my face!
Rejoice always in hope and pray constantly. When our thoughts return to (what we are) and (who we represent), IntelliSense not working on the Sheets object becomes completely insignificant. That worked! Thanks!

[Aussiebear]

Have a read here...https://software-solutions-online.com/vba-intellisense-not-working/