Ctrl-J list of properties and methods
 

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

Ctrl-J list of properties and methods
 

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



---
Regards,
Norman



"Fred Holmes" wrote in message
...
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