Intellisense not working

  • Thread starter Thread starter Edward
  • Start date Start date
E

Edward

Hi everybody,
In Excel Intellisense is not working (Auto list members is checked) , Any
thoughts?
 
In Excel Tools>Options>View>Function Tool Tips needs to be checked.
In VBA Tools>Options>Editor>Auto List Members needs to be checked.
 
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
 
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)
 
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 !
 
Back
Top