IntelliSense Problem

[Glen]

Hello, I just switched to a new Desktop at work with Excel 2003. My
Intellisense property lists do not appear in VBA and I am having
trouble finding out how to activate it. Any suggestions? Thanks in
advance.

 

[Tom Ogilvy]

In the VBE, in tools=>Options on the first tab (Editor) in the Code Settings
Frame, are the last 3 "Auto" options checked?

 

[Glen]

Thank you for your response Tom. The first thing I checked were the
options under Tools and yes they are checked. Do you have any other
suggestions?

 

[Tom Ogilvy]

If none are working, then no.

If some are and some are not, then I would say look an make sure you have
the proper object libraries referenced (and in tools=>references, nothing
shown as MISSING) and that your variables are declared with the proper type.
Make sure you have declared local names/variables which mask standard ones.
all just guesses of course.

 

[Glen]

Thanks for your help Tom. I just inherited this PC from another user
so I ended up checking for updates for office and windows and found
some errors with office. Oddly enough, I patched Office and it works
fine. Sorry to have wasted your time.

Sincerely,
Glen