VBA Editor not autocompleting

[eduzs]

Why is my VBA Excel editor not autocompleting while I type the code?
For example: if I type "Selection". I'll usually expect to see the list of things I can do with it.
Maybe I disabled any setting?

Thanks

 

[DanteAmor]

Thanks! You're right if I plan to use Intellisense I need firstly set selection as a range variable object.

Dim oRng As Range
Set oRng = Selection
Debug.Print oRng.Cells.Count

First you must declare the variable or the object appropriately.
For example

activesheet. (dont show)

dim sh as worksheet
set sh = activesheet
sh. (Show)

 

[footoo]

First you must declare the variable or the object appropriately.
For example

activesheet. (dont show)

dim sh as worksheet
set sh = activesheet
sh. (Show)

Will produce an error if the active sheet is not a worksheet.

 

[Macropod]

Just to be on the safe side, then, you might test what's selected, via:
TypeName(Selection)

 

[footoo]

Just to be on the safe side, then, you might test what's selected, via:
TypeName(Selection)

I think you mean via : TypeName(ActiveSheet)

 

[Macropod]

No, I meant TypeName(Selection). After all, I did say:

you might test what's selected

 

[footoo]

No, I meant TypeName(Selection). After all, I did say:

If you were referring to post # 12 (which was the one immediately before yours) then it should be TypeName(ActiveSheet)
If you were referring some earlier posts re worksheet range selection then see post # 5

 

[RoryA]

Even if I select a range of cells "Selection." Intellisense does not work.

It doesn't matter what you selected before typing that. The Selection property returns a generic Object so there is no way for Intellisense to know what properties and methods might be available for whatever may end up being selected when the code actually runs.

 

[eduzs]

I understand, however, I think there is no reason why it should not work when the selected object is a range, with or without variable declaration, or in simple situations like "cells(1,1).", it is only basically a app limitation.

 

[RoryA]

How could the compiler possibly know at design time what would be selected at run time?

I agree that Cells.Item should provide intelligence since it will provide a Range object, but that's an object model limitation rather than an application one per se.

 

[DanteAmor]

Will produce an error if the active sheet is not a worksheet.

Can you show how an activesheet is not a worksheet?
And what error message does it send you?

This work for me

[COLOR=#333333][I]set sh = activesheet[/I][/COLOR]