Ctrl-J list of properties and methods

[Fred Holmes]

When I type in the following statement:

n = ActiveWorkbook.ActiveSheet.Index

When I type in the last period in the statement, I don't automatically
get the tool-tip list of properties and methods (from which I would
pick "Index"). Nor can I bring up the list with Ctrl-J.

Nor can I bring up anything with Ctrl-Shift-J, Ctrl-I, or
Ctrl-Shift-I, i.e., Constants, Quick Info, or Parameter Info.

Any good reason for this? Any other list I can bring up to hunt for
the property or method I'm looking for? e.g. bring up Index and
CodeName?

This happens quite often at other points in typing in code.

Thanks,

Fred Holmes

 

[Norman Jones]

Hi Fred,

Intellisense responds to dimmed variables.

Trying your code this way should invoke the intervention of intellisense.

Sub Test()
Dim sh As Worksheet

Set sh = ActiveSheet
n = sh.Index

End Sub