Intellisense not working

[Edward]

Hi everybody,
In Excel Intellisense is not working (Auto list members is checked) , Any
thoughts?

 

[JLGWhiz]

In Excel Tools>Options>View>Function Tool Tips needs to be checked.
In VBA Tools>Options>Editor>Auto List Members needs to be checked.

 

[Edward]

in VBA Auto list is checked and in EXcel function tool tips which is in
general tab is checked as well, but still is not working.
Thanks

 

[Chip Pearson]

Try running "Compile" from the Debug menu to be sure you have no
outstanding compiler errors. Intellisense sometimes refuses to show
its face with there is a compiler error.

Cordially,
Chip Pearson
Microsoft MVP
Excel Product Group
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)

 

[Edward]

Actually I don't have any compile error . Here is the case when I start lets
say
Activeworkbook. nothing happens I mean after "dot" intellisense dosen't show
up but if use
dim wb as workbook
set wb=Activeworkbook

wb.
now intellisense shows up !