Jesus_Loves
03-04-2022, 09:11 AM
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?
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?