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

 

[footoo]

https://www.google.com/search?safe=........0i71j35i304i39j0i13j0i8i7i30.nHu7g1CVaHM

 

[RoryA]

Selection could be any type of object, so Intellisense can't really help you with that.

 

[eduzs]

Thanks all! I did not know it name is Intellisense.
And yes, VBA can't know what is the object.
Thanks.

 

[footoo]

To get intellisense based on selection, would need like this (using a range object for purpose of example) :

Dim rng As Range
If TypeName(Selection) = "Range" Then
    Set rng = Selection
    [COLOR=#ff0000]rng.[/COLOR]
End If

 

[Macropod]

Excel's Intellisense seems lame by comparison with Word in this area, where Intellisense works quite happily even for Selection.

 

[RoryA]

That's a difference in the OM. In Word, there is a Selection class whereas there isn't in Excel, where I guess there are perhaps more options for what the selection might be, though I confess I have no idea how most of the selection properties would behave if you hadn't selected some text.

 

[eduzs]

Excel's Intellisense seems lame by comparison with Word in this area, where Intellisense works quite happily even for Selection.

I also think this, Intellisense works much more in Word.
Even a simple "cells(1,1)." Intellisense does not work, but works in "Range("A1")."
Even if I select a range of cells "Selection." Intellisense does not work.
Thanks

 

[eduzs]

To get intellisense based on selection, would need like this (using a range object for purpose of example) :

Dim rng As Range
If TypeName(Selection) = "Range" Then
    Set rng = Selection
    [COLOR=#ff0000]rng.[/COLOR]
End If

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

 

[footoo]

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

If the selection is it not a range, this code will produce an error.
To avoid this, need to check that the selection is a range object (see post # 5).